Learn Better Ways to Manage Your Cache in ASP.NET
Learn how to use caching effectively today and tomorrow with some new (and some not-quite-as-new) cache management techniques for ASP.NET 1.x and 2.0.
Caching is one of the features in ASP.NET 1.x that most developers are familiar with. And it has helped to fuel a yearning for cache dependency in SQL Server. The ability to refresh the cache if a row in a table has been modified is very useful to a lot of developers. And hence in ASP.NET 2.0, Microsoft built SQL Server cache dependency right into the product.
Read more here http://www.devx.com/asp/Article/21751/1954?pf=true