Caching and Sql2000

Topics: Caching Application Block
Nov 5, 2007 at 10:47 AM
In my ASP.NET/SQL2K app I use SqlCacheDependency to good effect with regards to lookup tables. I have various Windows services that I would like to implement similar caching pattern i.e. only update the cache when something in the database changes.

Has anyone any idea on how to achieve this using EntLib, SQL2K and .net 2.0?

TIA
swin
Jan 2, 2008 at 11:31 AM
Yeah.. i did it for SQL Server2000 and now doing for SQL Server 2005.