October 2010
Intermediate to advanced
1920 pages
73h 55m
English
A Polling SQL cache dependency is the most flexible type of SQL cache dependency, and I recommend that you use Polling rather than Push SQL cache dependencies for most applications. You can use a Polling SQL cache dependency to detect any type of modification to a database table.
Behind the scenes, a Polling SQL cache dependency uses a database trigger. When a table is modified, the trigger fires, and a row in a database table named AspNet_SqlCacheTablesForChangeNotification is updated to record that the table has been changed.
The ASP.NET Framework uses a background thread to poll this database table for changes on a periodic basis. If there has been a change, any item in the cache that is dependent on the ...
Read now
Unlock full access