Initializes a new instance of the SqlCacheDependency class, using the supplied connection string and query string.

Namespace: Alachisoft.NCache.Runtime.Dependencies
Assembly: Alachisoft.NCache.Runtime (in Alachisoft.NCache.Runtime.dll) Version: (


public SqlCacheDependency(
	string connectionString,
	string cmdText
Visual Basic
Public Sub New ( _
	connectionString As String, _
	cmdText As String _
Visual C++
	String^ connectionString, 
	String^ cmdText


Type: System..::..String
connection string to be used by dependency.
Type: System..::..String
cmdText to be used by dependency.

Return Value

A SqlCacheDependency object based on the supplied parameters.


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

SQL query must include the following: Fully qualified table names, including the name of the table owner. For example, to refer to a table called "customers" that 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 customers", you must use "select name, address, city, state from dbo.customers".

See Also