ASP.NET 4 Unleashed

Using Push SQL Cache Dependencies with Data Caching

You can use Push SQL cache dependencies when working with the Cache object. You represent a Push SQL cache dependency with an instance of the SqlCacheDependency class.

For example, in the Page_Load() handler in Listing 29.48, a DataTable is added to the cache that represents the contents of the Movies database table. The DataTable displays in a GridView control.

Listing 29.48. PushSQLDataCache.aspx

An instance of the SqlCacheDependency class is created. A SqlCommand object is passed to the constructor ...