This documentation is archived and is not being maintained.

SqlCacheDependency.CreateOutputCacheDependency Method

Creates a dependency relationship between an item that is stored in an ASP.NET application's OutputCache object and a SQL Server database table.

Namespace:  System.Web.Caching
Assembly:  System.Web (in System.Web.dll)

public static CacheDependency CreateOutputCacheDependency(
	string dependency


Type: System.String
The output-cache dependency directive.

Return Value

Type: System.Web.Caching.CacheDependency
The new dependency object.

The following markup shows a typical output-cache dependency directive.

<%@ OutputCache Duration="3600" SqlDependency="Northwind:Employees" VaryByParam="none" %>

.NET Framework

Supported in: 4

Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

The .NET Framework does not support all versions of every platform. For a list of the supported versions, see .NET Framework System Requirements.