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 ADO.net 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

http://msdn.microsoft.com/en-us/library/aewzkxxh(v=vs.90).aspx

So how do you load NavigationProperties when using SQLDependency?

Any help is greatly appreciated. Thanks in Advance.

+3


source to share





All Articles