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

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

<databases>
    <add.../>
    <clear />
    <remove.../>
</databases>

Attributes and Elements

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. Note 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.

Remarks

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>

Example

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

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

Element Information

Configuration Section Handler	System.Web.Configuration.SqlCacheDependencySection
Configuration Member	System.Web.Configuration.SqlCacheDependencySection.Databases
Configurable Locations	Machine.config Root-level Web.config Application-level Web.config
Requirements	IIS version 5.0, 5.1 and 6.0 .NET Framework version 2.0 Visual Studio 2005

See Also

Tasks

How to: Configure Specific Directories Using Location Settings
How to: Lock ASP.NET Configuration Settings

Reference

system.web Element (ASP.NET Settings Schema)
configuration Element (General Settings Schema)
caching Element (ASP.NET Settings Schema)
sqlCacheDependency Element for caching (ASP.NET Settings Schema)
add Element for database for caching (ASP.NET Settings Schema)
clear Element for database for caching (ASP.NET Settings Schema)
remove Element for database for caching (ASP.NET Settings Schema)
System.Configuration
System.Web.Configuration

Concepts

ASP.NET Caching Overview
How-to Topics — ASP.NET Caching (Visual Studio)
ASP.NET Configuration File Hierarchy and Inheritance
Securing ASP.NET Configuration
ASP.NET Configuration Scenarios

Other Resources

Getting Started - Enhancing Web Site Performance with Caching
Learning More - About Enhancing Web Site Performance with Caching
ASP.NET Caching (Visual Studio)
General Configuration Settings (ASP.NET)
ASP.NET Configuration Settings
Configuring ASP.NET Applications
ASP.NET Configuration Files
ASP.NET Configuration API