SqlCacheDependencySection.Enabled Property

Definition

Namespace:

System.Web.Configuration

Assembly:

System.Web.dll

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

C#

[System.Configuration.ConfigurationProperty("enabled", DefaultValue=true)]
public bool Enabled { get; set; }

Property Value

Boolean

true if SQL cache monitoring is enabled; otherwise, false. The default is true.

Attributes

ConfigurationPropertyAttribute

Examples

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

C#

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

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

Remarks

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.

Anteckning

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.

Applies to

See also

• SqlCacheDependency
• Cache