SqlCacheDependencySection Class
Configures the SQL cache dependencies for an ASP.NET application. This class cannot be inherited.
Assembly: System.Web (in System.Web.dll)
System.Configuration::ConfigurationElement
System.Configuration::ConfigurationSection
System.Web.Configuration::SqlCacheDependencySection
| Name | Description | |
|---|---|---|
![]() | SqlCacheDependencySection() | This API supports the product infrastructure and is not intended to be used directly from your code. Initializes a new instance of the SqlCacheDependencySection class. |
| Name | Description | |
|---|---|---|
![]() | CurrentConfiguration | Gets a reference to the top-level Configuration instance that represents the configuration hierarchy that the current ConfigurationElement instance belongs to.(Inherited from ConfigurationElement.) |
![]() | Databases | Gets the collection of SqlCacheDependencyDatabase objects stored within the SqlCacheDependencySection. |
![]() | ElementInformation | Gets an ElementInformation object that contains the non-customizable information and functionality of the ConfigurationElement object. (Inherited from ConfigurationElement.) |
![]() | ElementProperty | Gets the ConfigurationElementProperty object that represents the ConfigurationElement object itself.(Inherited from ConfigurationElement.) |
![]() | Enabled | Gets or sets a value indicating whether the database table should be monitored for changes. |
![]() | Item[ConfigurationProperty^] | Gets or sets a property or attribute of this configuration element.(Inherited from ConfigurationElement.) |
![]() | Item[String^] | Gets or sets a property, attribute, or child element of this configuration element.(Inherited from ConfigurationElement.) |
![]() | LockAllAttributesExcept | Gets the collection of locked attributes.(Inherited from ConfigurationElement.) |
![]() | LockAllElementsExcept | Gets the collection of locked elements.(Inherited from ConfigurationElement.) |
![]() | LockAttributes | Gets the collection of locked attributes (Inherited from ConfigurationElement.) |
![]() | LockElements | Gets the collection of locked elements.(Inherited from ConfigurationElement.) |
![]() | LockItem | Gets or sets a value indicating whether the element is locked.(Inherited from ConfigurationElement.) |
![]() | PollTime | Gets or sets the frequency with which the SqlCacheDependency polls the database table for changes. |
![]() | Properties | Gets the collection of properties.(Inherited from ConfigurationElement.) |
![]() | SectionInformation | Gets a SectionInformation object that contains the non-customizable information and functionality of the ConfigurationSection object. (Inherited from ConfigurationSection.) |
| Name | Description | |
|---|---|---|
![]() | DeserializeElement(XmlReader^, Boolean) | Reads XML from the configuration file.(Inherited from ConfigurationElement.) |
![]() | DeserializeSection(XmlReader^) | This API supports the product infrastructure and is not intended to be used directly from your code. Reads XML from the configuration file.(Inherited from ConfigurationSection.) |
![]() | Equals(Object^) | Compares the current ConfigurationElement instance to the specified object.(Inherited from ConfigurationElement.) |
![]() | GetHashCode() | Gets a unique value representing the current ConfigurationElement instance.(Inherited from ConfigurationElement.) |
![]() | GetRuntimeObject() | Returns a custom object when overridden in a derived class.(Inherited from ConfigurationSection.) |
![]() | GetType() | |
![]() | Init() | Sets the ConfigurationElement object to its initial state.(Inherited from ConfigurationElement.) |
![]() | InitializeDefault() | Used to initialize a default set of values for the ConfigurationElement object.(Inherited from ConfigurationElement.) |
![]() | IsModified() | Indicates whether this configuration element has been modified since it was last saved or loaded when implemented in a derived class.(Inherited from ConfigurationSection.) |
![]() | IsReadOnly() | Gets a value indicating whether the ConfigurationElement object is read-only.(Inherited from ConfigurationElement.) |
![]() | Reset(ConfigurationElement^) | Resets the internal state of the ConfigurationElement object, including the locks and the properties collections.(Inherited from ConfigurationElement.) |
![]() | ResetModified() | Resets the value of the IsModified method to false when implemented in a derived class.(Inherited from ConfigurationSection.) |
![]() | SerializeElement(XmlWriter^, Boolean) | Writes the contents of this configuration element to the configuration file when implemented in a derived class.(Inherited from ConfigurationElement.) |
![]() | SerializeSection(ConfigurationElement^, String^, ConfigurationSaveMode) | This API supports the product infrastructure and is not intended to be used directly from your code. Creates an XML string containing an unmerged view of the ConfigurationSection object as a single section to write to a file.(Inherited from ConfigurationSection.) |
![]() | SerializeToXmlElement(XmlWriter^, String^) | Writes the outer tags of this configuration element to the configuration file when implemented in a derived class.(Inherited from ConfigurationElement.) |
![]() | SetReadOnly() | Sets the IsReadOnly property for the ConfigurationElement object and all subelements.(Inherited from ConfigurationElement.) |
![]() | ShouldSerializeElementInTargetVersion(ConfigurationElement^, String^, FrameworkName^) | Indicates whether the specified element should be serialized when the configuration object hierarchy is serialized for the specified target version of the .NET Framework.(Inherited from ConfigurationSection.) |
![]() | ShouldSerializePropertyInTargetVersion(ConfigurationProperty^, String^, FrameworkName^, ConfigurationElement^) | Indicates whether the specified property should be serialized when the configuration object hierarchy is serialized for the specified target version of the .NET Framework.(Inherited from ConfigurationSection.) |
![]() | ShouldSerializeSectionInTargetVersion(FrameworkName^) | Indicates whether the current ConfigurationSection instance should be serialized when the configuration object hierarchy is serialized for the specified target version of the .NET Framework.(Inherited from ConfigurationSection.) |
![]() | ToString() | Returns a string that represents the current object.(Inherited from Object.) |
![]() | Unmerge(ConfigurationElement^, ConfigurationElement^, ConfigurationSaveMode) | Modifies the ConfigurationElement object to remove all values that should not be saved. (Inherited from ConfigurationElement.) |
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.
Note |
|---|
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. |
Available since 2.0
Any public static ( Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.




