CACHING WITH SQL DEPENDENCY SUPPORT-1
Caching data that comes from an SQL database (in other words
dependencies to database tables) in RAM has been supported since
ASP.NET 2.0. In practice this means, we can cache the data for
undetermined period until the source database table is updated. This
cache mechanism works for SQL Server 7 and later including SQL 2005 and
SQL 2008. SQL 2005 and SQL 2008 supports another type of cache
invalidation based on events. I call first mechanism as Table Level SQL Dependencies and second as Command Level SQL Dependencies.
In this article, "Table Level SQL Dependencies" will be spoken. For
"Command Level SQL Dependencies" you can look at "Caching with SQL
Dependency Support-2". [Further...]