System.Web.Configuration.SqlCacheDependencySection Class

Configures the SQL cache dependencies for an ASP.NET application. This class cannot be inherited.

See Also: SqlCacheDependencySection Members


public sealed class SqlCacheDependencySection : System.Configuration.ConfigurationSection


The System.Web.Configuration.SqlCacheDependencySection allows you to programmatically access and modify the sqlCacheDependency element of the cache configuration section.

The SQL cache dependency allows the cached data to be synchronized with the original source. After you configure the relationship between an item stored in an ASP.NET application's cache and a specific SQL Server database table, an instance of the System.Web.Caching.SqlCacheDependency class monitors the table so that when an item in the table changes, the item is automatically removed from the cache.

The settings in this element only affect the table-based version of the System.Web.Caching.SqlCacheDependency object. The row-level System.Web.Caching.SqlCacheDependency objects used with sqprsqlong and above are not affected by these settings.


The System.Web.Configuration.SqlCacheDependencySection can write information into the related section of the configuration file according to the restrictions defined by the section property System.Configuration.SectionInformation.AllowDefinition whose value is System.Configuration.ConfigurationAllowDefinition.MachineToApplication. Any attempt to write in a configuration file at a level not allowed in the hierarchy will result in an error message generated by the parser. However, you can use this class to read configuration information at any level in the hierarchy.


Namespace: System.Web.Configuration
Assembly: System.Web (in System.Web.dll)
Assembly Versions:
Since: .NET 2.0