SQL Cache Dependency in ASP.NET: It is the mechanism where the cache object gets invalidated when the related data or the related resource is modified. It is a feature in SQL Server 2005 and SQL Server 2000.
3 types of SQL-cache dependencies exist:
a. Other cache items.
c. Dependencies on a database query.