Database cache invalidation
There is a nice
article on the MSDN-site about database cache invalidation for ASP.NET 1.1. It shows how you can invalidate items in the cache based on changes in the database. It’s a relative simple solution that uses polling on a change notification table. In ASP.NET 2.0 database cache invalidation is implemented in the same way for SQL-Server 7.0 and 2000.