Notes when adding data cache dependencies to user controls in Asp.net

Aggregatecachedependency in system. Web. caching

The cachepolicy. Dependency attribute may be assigned to the user control.

The aggregatecachedependency class can contain many sqlcachedependency objects.

Sqlcachedependency: New sqlcachedependency (database, table );

 

The database must be specified in caching in Web. config, that is, the connection object of the specified database.

 

<Caching>
<Sqlcachedependency enabled = "true" polltime = "10000">
<Databases>
<Add name = "mspetshop4" connectionstringname = "sqlconnstring1" polltime = "10000"/>
</Databases>
</Sqlcachedependency>
</Caching>