ASP. NET 2.0 SQL cache configuration method

Function: When the database changes, the connection pool will notify IIS to refresh the page Cache

1. Configure the connection pool:
Aspnet_regsql.exe-s "server"-e-d "Database"-ed
Aspnet_regsql.exe-s "server"-e-d "Database"-et-T "tablename"

You cannot monitor too many databases and tables.

2. modify web. config

Under <system. Web>, add:

< Caching >
< Sqlcachedependency Enabled = "True" Polltime = "500" >
< Databases >
< Add Name = "Dependencyname" Connectionstringname = "Readwrite" />
</ Databases >
</ Sqlcachedependency >
</ Caching >

 
3. Add:

<% @ Outputcache duration = " 99999 " Varybyparam = " None " Sqldependency = " Dependencyname: tablename "   %>

The cache is refreshed only when the table tablename changes. You can also set the duration to a smaller value, and automatically refresh the cache by the time.