Sqlcachedependency not invalidating

In the following example we’ll use SQL Server 2005 and the Pubs database.

sqlcachedependency not invalidating-28

For the website to be able to receive notifications, a listener must be created. I decided to wrap the code up into an Extension Method. Add a new Class file to the application and name it My Extensions.

Extension methods are static methods, so you must mark the class as static.

NET, the first thing that comes to mind is caching.

Simply put caching is an in memory storage of objects that enables the application to read and write data to memory. NET has several different varieties of caching features.

The developer can now tell SQL Server to push notifications when data has changed.