有许多 Web 应用程序（asp.net、mvc 和经典 asp）在 IIS 上运行，它们从特定的 SQL Server 数据库表获取缓存。当表中的任何行被更新时，应该设置一些触发机制，以便它出去并刷新受该数据影响的任何缓存。
简而言之，当缓存从中获取数据的 SQL 表刷新时，如何刷新 ASP.net 缓存？
There are a bunch of web applications (asp.net, mvc and classic asp) running on IIS, that get their cache from a particular SQL server database table. When any row is updated in the table, some trigger mechanism should be set, so that it goes out and refreshes any cache that is affected by this data.
So in short, how do I refresh ASP.net cache as soon as the SQL table the cache is getting data from is refreshed?
发布评论
评论（2）
我自己没有这样做过 - 但您可能想看看这个：
http://msdn.microsoft.com/en-us/library/e3w8402y(v=vs.80).aspx
I haven't done this myself - but you might want to take a look at this:
http://msdn.microsoft.com/en-us/library/e3w8402y(v=vs.80).aspx
SqlCacheDependency 类有助于
http://msdn.microsoft.com/ en-us/library/system.web.caching.sqlcachedependency.aspx
SqlCacheDependency Class helps
http://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependency.aspx