SqlCacheDependencySection Class

Article
05/20/2022

Represents a System.Web.Caching.SqlCacheDependency configuration section.

Syntax

class SqlCacheDependencySection : ConfigurationSectionWithCollection

Methods

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`.)

Properties

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`.)

Subclasses

This class contains no subclasses.

Remarks

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.

Inheritance Hierarchy

ConfigurationSection

ConfigurationSectionWithCollection

SqlCacheDependencySection

Requirements

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

Share via