Establishes a relationship between an item stored in an application's Cache object and either a row in a specific SQL Server database table or the results of a SQL Server 2005 query.
[Serializable] public sealed class SqlCacheDependency : CacheDependency, IDisposable
You can add items with dependencies to your application's cache with the
When you add an item to an application's
Initializes a new instance of the SqlCacheDependency class, using the supplied connection string and query string.
|SqlCacheDependency(String, String, SqlCommandType, Dictionary<String, SqlCmdParams>)||
Initializes a new instance of the SqlCacheDependency class. It supports the use of 'Stored Procedures'.
Parameters to be used by dependency.
CommandText to be used by dependency.
Describes the type of the SQL command passed to the SQLDependency.
Connection String is the connection string that is required to the cache in order to connect with database.