CODEWITHSUNDEEP
.netsql-serveriiscaching
developer747
developer747

Reputation: 15928

Refresh cache based on a database refresh

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?

Upvotes: 4

Views: 3065

Answers (2)

developer747
developer747

Reputation: 15928

SqlCacheDependency Class helps

http://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependency.aspx

Upvotes: 1

user806549
user806549

Reputation:

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

Upvotes: 2

Related Questions