Class SqlCacheDependency
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.
Inherited Members
Assembly: Alachisoft.NCache.Runtime.dll
Syntax
[Obsolete("This API is deprecated and will be removed in a future release. This feature is being retired and will not be continued in future versions.", false)]
public sealed class SqlCacheDependency : CacheDependency, IDisposable, IBinaryProtocolSerializable
Remarks
You can add items with dependencies to your application's cache with the specific overloads of Add and Insert methods.
When you add an item to an application's cache object with
Sql
This helps you to avoid losing changes made to the object between the time it is created and the
time it is inserted into the cache.
Sql
Constructors
Name | Description |
---|---|
Sql |
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'. |
Properties
Name | Description |
---|---|
Command |
Parameters to be used by the dependency. |
Command |
SQL statement, table name or stored procedure to be executed on the data source. |
Command |
Describes the type of the SQL command passed to the SQLDependency. |
Connection |
The connection string that is required to the cache in order to connect with database. |