How to apply Sql Dependency in ASP.NET MVC?

asp.net-mvc sqldependency
Rishabh Ohri picture Rishabh Ohri · Feb 3, 2010 · Viewed 7.1k times · Source

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

Answer

Robert Harvey picture Robert Harvey · Feb 3, 2010

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

Related questions

JQuery - $ is not defined

I have a simple jquery click event <script type="text/javascript"> $(function() { $('#post').click(function() { alert("test"); }); }); </script> and a jquery reference defined in the site.master <script src="<%=ResolveUrl("~/Scripts/jquery-1.3.2.js")%&…

Read More
A potentially dangerous Request.Form value was detected from the client

Every time a user posts something containing < or > in a page in my web application, I get this exception thrown. I don't want to go into the discussion about the smartness of throwing an exception or crashing an …

Read More
Send JSON data via POST (ajax) and receive json response from Controller (MVC)

I created a function in javascript like that: function addNewManufacturer() { var name = $("#id-manuf-name").val(); var address = $("#id-manuf-address").val(); var phone = $("#id-manuf-phone").val(); var sendInfo = { Name: name, Address: address, Phone: phone }; $.ajax({ type: "POST", url: "/Home/Add", dataType: "json", success: function (…

Read More