Configuration in Web. config
< System. Web >
< Caching >
< Sqlcachedependency Enabled = " True " Polltime = " Polling time (MS) " >
< Databases >
< Add name = " Name " Connectionstringname = " Name of the connection string " />
</ Databases >
</ Sqlcachedependency >
<! -- If it is sqlserver2005, you only need to set it as follows, because sqlserver supports notification-based cache failure.
< Sqlcachedependency Enabled = " True " />
-->
</ Caching >
</ System. Web >
Register with aspnet_regsql
Windows Verification
Aspnet_regsql.exe-s "server"-e-d "Database"-ed
Aspnet_regsql.exe-s "server"-e-d "Database"-et-T "table"
SQL Verification
Aspnet_regsql.exe-s "server"-u username-P password-d "Database"-ed
Aspnet_regsql.exe-s "server"-u username-P password-d "Database"-et-T "table"
It is easy to remember and use. Just put it in the beginner's zone.
