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
No one has answered this question yet
Check out similar questions: