This documentation is archived and is not being maintained.

databases Element for sqlCacheDependency for caching (ASP.NET Settings Schema)

Contains one or more named SQL connections that can be used by the SqlCacheDependency.

configuration Element (General Settings Schema)
  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.

NoteNote
This 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>

The following example adds a SqlCacheDependency to an ASP.NET application.

<sqlCacheDependency enabled="true" pollTime="30000">
  <databases>
    <add name="Pubs" connectionStringName="PubsConn" />
  </databases>
</sqlCacheDependency>

Configuration section handler

CompilationSection

Configuration member

Compilation

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

Show: