Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SqlCacheDependency Constructor (SqlCommand)

SqlCacheDependency Constructor (SqlCommand)

Initializes a new instance of the SqlCacheDependency class, using the supplied SqlCommand to create a cache-key dependency.

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

public SqlCacheDependency(
	SqlCommand sqlCmd


Type: System.Data.SqlClient.SqlCommand

A SqlCommand that is used to create a SqlCacheDependency object.


The sqlCmd parameter is null.


The SqlCommand instance has its NotificationAutoEnlist property set to true and there is an @ OutputCache directive on the page with the SqlDependency attribute set to CommandNotification.

This constructor is used to create SqlCacheDependency objects that use the query-notification feature of SQL Server 2005 products.

SQL statements that are associated with the sqlCmd parameter must include the following:

  • Fully qualified table names, including the name of the table owner. For example, to refer to a table named Customersthat is owned by the database owner, the SQL statement must refer to dbo.customers.

  • Explicit column names in the Select statement. You cannot use the asterisk (*) wildcard character to select all columns from a table. For example, instead of select * from dbo.customers, you must use select name, address, city, state from dbo.customers.

This constructor cannot be used to associate a SqlCommand instance with a SqlCacheDependency instance on a page using SQL Server 2005 query notifications with page-level output caching.

.NET Framework

Supported in: 4.6, 4.5, 4, 3.5, 3.0, 2.0
© 2015 Microsoft