How can we apply Sql Dependency in Asp.Net MVC for cached objects?
MSDN says:
To set up a dependency, you need to associate a SqlDependency object to one or more SqlCommand objects. To receive notifications, you need to subscribe to the OnChange event.
If you are using an ORM for your data model, I'm not sure how this applies.
More info here:
http://msdn.microsoft.com/en-us/library/t9x04ed2.aspx
Also you can use SqlDependency with Entity Framework 5.you use following link: http://www.codeproject.com/Articles/496484/SqlDependency-with-Entity-Framework-5-0
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With