SqlCacheDependencySection Class

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

Namespace: System.Web.Configuration
Assembly: System.Web (in system.web.dll)

public sealed class SqlCacheDependencySection : ConfigurationSection
public final class SqlCacheDependencySection extends ConfigurationSection
public final class SqlCacheDependencySection extends ConfigurationSection
Not applicable.

The 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 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 SqlCacheDependency object. The row-level SqlCacheDependency objects used with SQL Server 2005 and above are not affected by these settings.


The SqlCacheDependencySection can write information into the related section of the configuration file according to the restrictions defined by the section property AllowDefinition whose value is 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.

The following code example shows how to obtain the SqlCacheDependencySection object from the configuration file of an existing Web application.

// Get the Web application configuration.
System.Configuration.Configuration webConfig = 

// Get the section.
string configPath = "system.web/cache/sqlCacheDependency";
System.Web.Configuration.SqlCacheDependencySection sqlDs = 


Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Windows 98, Windows Server 2000 SP4, Windows Server 2003, Windows XP Media Center Edition, Windows XP Professional x64 Edition, Windows XP SP2, Windows XP Starter Edition

The Microsoft .NET Framework 3.0 is supported on Windows Vista, Microsoft Windows XP SP2, and Windows Server 2003 SP1.

.NET Framework

Supported in: 3.0, 2.0

Community Additions