SQL Cache Dependency in ASP.NET 2.0

SQL cache dependencies is a new feature in ASP.NET 2.0 which can automatically invalidate a cached data object (such as a Dataset) when the related data is modified in the database. So for instance if you have a dataset which is tied up to a database tables any changes in the database table will invalidate the cached data object which can be a dataset or a data source.

Steps to enable SQL Cache Dependency in ASP.NET 2.0

• Enable notifications for the database.

• Enable notifications for individual tables.

• Enable ASP.NET polling using "web.config" file.

• Finally use the Cache dependency object in your ASP.NET code.