Home > DeveloperSection > Interviews > What is SQL Cache Dependency in ASP.NET?

Posted on    October-25-2010 12:00 AM

 ASP.Net ASP.Net 
 1 Answer(s)
  1128  View(s)
Rate this:

Pushpendra Singh

Total Post:241

Posted on    October-26-2010 12:00 AM

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.
b. Files/folders.
c. Dependencies on a database query.

Don't want to miss updates? Please click the below button!

Follow MindStick