Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to apply Sql Dependency in ASP.NET MVC?

How can we apply Sql Dependency in Asp.Net MVC for cached objects?

like image 674
Rishabh Ohri Avatar asked Feb 03 '10 14:02

Rishabh Ohri


2 Answers

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

like image 131
Robert Harvey Avatar answered Sep 23 '22 21:09

Robert Harvey


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

like image 36
Hossein Moradinia Avatar answered Sep 20 '22 21:09

Hossein Moradinia