Share via


add Element for database for caching (ASP.NET Settings Schema)

Adds a SqlCacheDependencyDatabase object to the configuration collection.

<add name="String" 
     connectionStringName="String" 
     pollTime="number"/>

Attributes and Elements

The following sections describe attributes, child elements, and parent elements.

Attributes

Attribute Description

connectionStringName

Required String attribute.

Sets the connection string name for the database. References a connection string in the connectionStrings Element (ASP.NET Settings Schema) configuration section.

name

Required String attribute.

The name of the SqlCacheDependencyDatabase object to add to the configuration collection.

This name is used as part of the SqlDependency attribute on the @ OutputCache directive.

pollTime

Optional Int32 attribute.

Sets the frequency in milliseconds with which the SqlCacheDependency polls the database table for changes.

Child Elements

None.

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.

databases

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

Remarks

Default Configuration

The following default add 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>

Example

The following example adds a SqlCacheDependencyDatabase object 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 5.0, 5.1 and 6.0

.NET Framework 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)
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
ASP.NET Configuration File Hierarchy and Inheritance
Securing ASP.NET Configuration
ASP.NET Configuration Scenarios

Other Resources

General Configuration Settings (ASP.NET)
ASP.NET Configuration Settings
Configuring ASP.NET Applications
ASP.NET Configuration Files
ASP.NET Configuration API