This documentation is archived and is not being maintained.

SqlCacheDependencySection.Enabled Property

Gets or sets a value indicating whether the database table should be monitored for changes.

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

[ConfigurationPropertyAttribute("enabled", DefaultValue = true)]
public bool Enabled { get; set; }

Property Value

Type: System.Boolean
true if SQL cache monitoring is enabled; otherwise, false. The default is true.

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.

For this class to work correctly, the database and any tables on which you want to set dependencies must have notifications enabled. For more information, see the remarks provided for the SqlCacheDependency class.


Gets or sets a value indicating whether the database tables that have active SqlCacheDependency objects should be monitored for changes. This setting does not affect the row-level SqlCacheDependency objects.

The following code example shows how to use the Enabled property.

        // Get the current Enabled property value.
        Boolean enabledValue = sqlDs.Enabled;

        // Set the Enabled property to false.
        sqlDs.Enabled = false;

.NET Framework

Supported in: 4, 3.5, 3.0, 2.0

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows XP SP2 x64 Edition, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.