Class OracleCacheDependency

Establishes a relationship between an item stored in an application's Cache object and either a row in a specific Oracle database table or the results of a Oracle query. This class can not be inherited.

Inheritance
System.Object
CacheDependency
OracleCacheDependency
Inherited Members
Namespace:
Assembly: Alachisoft.NCache.Runtime.dll
Syntax
public sealed class OracleCacheDependency : CacheDependency
Remarks

You can add items with dependencies to your application's cache with the and Add,Insert, AddDependency methods.

When you add an item to an application's object with OracleCacheDependency, on all ODP.NET supported versions of Oracle database, it monitors a row in a specific Oracle database table so that when that row changes, items associated with the row will be automatically removed from the Cache.
This helps you avoid losing changes made to the object between the time it is created and the time it is inserted into the . OracleCacheDependency class supports the association of cached items with a Oracle query.

Constructors

OracleCacheDependency(String, String)

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

Declaration
public OracleCacheDependency(string connectionString, string cmdText)
Parameters
Type Name Description
System.String connectionString

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

cmdText to be used by dependency.
Remarks

This constructor is used to create OracleCacheDependency objects that use the query-notification feature of Oracle products.

Query must include the following:

OracleCacheDependency(String, String, OracleCommandType, Dictionary<String, OracleCmdParams>)

Initializes a new instance of the OracleCacheDependency class. It supports the use of stored procedures.

Declaration
public OracleCacheDependency(string connectionString, string cmdText, OracleCommandType cmdType, Dictionary<string, OracleCmdParams> cmdParams)
Parameters
Type Name Description
System.String connectionString

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

cmdText to be used by dependency.
OracleCommandType cmdType

The type of the command. (text/stored procedures)
Dictionary<System.String, OracleCmdParams> cmdParams

Parameters to be passed to the command.
Remarks

This constructor is used to create OracleCacheDependency objects that use the query-notification feature of Oracle products.

Query must include the following:

Properties

CommandParams

Declaration
public Dictionary<string, OracleCmdParams> CommandParams { get; }
Property Value
Type Description
Dictionary<System.String, OracleCmdParams>

CommandText

Declaration
public string CommandText { get; }
Property Value
Type Description
System.String

CommandType

Declaration
public CommandType CommandType { get; }
Property Value
Type Description
CommandType

ConnectionString

Declaration
public string ConnectionString { get; }
Property Value
Type Description
System.String