How to use SQLDependency with EntityFramework NavigationProperties

I am using SQLDependency for caching purposes and EntityFramwework on top of it. Few of my objects have navigation properties. Which I was trying to access with Eager Loading like below

entity.Include ("NavigationProperty");

and I set IsLazyLoading = false by default.

Intenally creates a "Mutual SQL Query" query to include a Linq query.

According to MSDN "Outside Joins" are not supported in QueryNotification. Below is the link

So how do you load NavigationProperties when using SQLDependency?

Any help is greatly appreciated. Thanks in Advance.


source to share

All Articles