databases Element for sqlCacheDependency for caching (ASP.NET Settings Schema)
Contains one or more named SQL connections that can be used by the SqlCacheDependency.
system.web Element (ASP.NET Settings Schema)
caching Element (ASP.NET Settings Schema)
sqlCacheDependency Element for caching (ASP.NET Settings Schema)
databases Element for sqlCacheDependency for caching (ASP.NET Settings Schema)
<databases>
<add.../>
<clear />
<remove.../>
</databases>
The following sections describe attributes, child elements, and parent elements.
Attributes
None.
Child Elements
Element | Description |
|---|---|
add | Optional element. Adds a SqlCacheDependencyDatabase object to the configuration collection. |
clear | Optional element. Removes all the SqlCacheDependencyDatabase objects from the configuration collection. |
remove | Optional element. Removes a named connection string from the configuration collection. NoteThis also removes inherited values. |
Parent Elements
Element | Description |
|---|---|
configuration | The required root element in every configuration file used by the common language runtime and .NET Framework applications. |
system.web | Specifies the root element for the ASP.NET configuration settings in a configuration file. Contains configuration elements that configure ASP.NET Web applications and control how the applications behave. |
caching | Configures the cache settings for a Web application. |
sqlCacheDependency | Defines the settings used by the SqlCacheDependency class. |
Default Configuration
The following default databases element is not explicitly configured in the machine configuration file or in the root Web.config file, but is the default configuration returned by an application in the .NET Framework version 2.0.
<sqlCacheDependency enabled = "true"
pollTime = "60000">
<databases>
<add name = ""
connectionStringName = ""
pollTime = "60000"/>
</databases>
</sqlCacheDependency>
<sqlCacheDependency enabled="true"
pollTime="60000">
<databases>
<clear />
</databases>
</sqlCacheDependency>
Configuration section handler | |
Configuration member | |
Configurable locations | Machine.config Root-level Web.config Application-level Web.config Virtual or physical directory–level Web.config |
Requirements | Microsoft Internet Information Services (IIS) 5.0, 5.1, or 6.0 .NET Framework 1.0, 1.1, 2.0 Visual Studio 2003, or Visual Studio 2005 |
Note