SqlCacheDependencySection Class
Represents a System.Web.Caching.SqlCacheDependency configuration section.
class SqlCacheDependencySection : ConfigurationSectionWithCollection
The following table lists the methods exposed by the SqlCacheDependencySection class.
| Name | Description |
|---|---|
| Add | (Inherited from ConfigurationSectionWithCollection.) |
| Clear | (Inherited from ConfigurationSectionWithCollection.) |
| Get | (Inherited from ConfigurationSectionWithCollection.) |
| GetAllowDefinition | (Inherited from ConfigurationSection.) |
| GetAllowLocation | (Inherited from ConfigurationSection.) |
| Remove | (Inherited from ConfigurationSectionWithCollection.) |
| RevertToParent | (Inherited from ConfigurationSection.) |
| SetAllowDefinition | (Inherited from ConfigurationSection.) |
| SetAllowLocation | (Inherited from ConfigurationSection.) |
The following table lists the properties exposed by the SqlCacheDependencySection class.
| Name | Description |
|---|---|
Databases |
A SqlCacheDependencyDatabaseSettings value that contains configuration settings for cached SQL data in ASP.NET caches. |
Enabled |
A boolean value. true if IIS is enabled to receive notifications of changes to cached SQL data; otherwise, false. The default is true. |
Location |
(Inherited from ConfigurationSection.) A key property. |
Path |
(Inherited from ConfigurationSection.) A key property. |
PollTime |
A sint32 value that represents, in milliseconds, how often SQL databases are queried for changes to cached data. The default is 60000. This property cannot be set to less than 500. |
SectionInformation |
(Inherited from ConfigurationSection.) |
This class contains no subclasses.
This class allows data stored in an ASP.NET application System.Web.Caching.Cache object to be updated when changes are made to its SQL Server data source (table or query). When the database table or query changes, the cached item is automatically deleted, and a new version of the item is added to the ASP.NET cache.
ConfigurationSectionWithCollection
SqlCacheDependencySection
| Type | Description |
|---|---|
| Client | - IIS 7.0 on Windows Vista - IIS 7.5 on Windows 7 - IIS 8.0 on Windows 8 - IIS 10.0 on Windows 10 |
| Server | - IIS 7.0 on Windows Server 2008 - IIS 7.5 on Windows Server 2008 R2 - IIS 8.0 on Windows Server 2012 - IIS 8.5 on Windows Server 2012 R2 - IIS 10.0 on Windows Server 2016 |
| Product | - IIS 7.0, IIS 7.5, IIS 8.0, IIS 8.5, IIS 10.0 |
| MOF file | WebAdministration.mof |
System.Web.Caching.SqlCacheDependency
System.Web.Caching.Cache
ConfigurationSectionWithCollection Class
SqlCacheDependencyDatabase Class
SqlCacheDependencyDatabaseSettings Class