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
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
So how do you load NavigationProperties when using SQLDependency?
Any help is greatly appreciated. Thanks in Advance.
source to share
No one has answered this question yet
Check out similar questions: