SqlCacheDependency Constructor (SqlCommand^)
Initializes a new instance of the SqlCacheDependency class, using the supplied SqlCommand to create a cache-key dependency.
Assembly: System.Web (in System.Web.dll)
Parameters
- sqlCmd
-
Type:
System.Data.SqlClient::SqlCommand^
A SqlCommand that is used to create a SqlCacheDependency object.
| Exception | Condition |
|---|---|
| ArgumentNullException | The sqlCmd parameter is null. |
| HttpException | The SqlCommand instance has its NotificationAutoEnlist property set to true and there is an 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.
Available since 2.0