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 an Oracle query. This class cannot be inherited.
Inherited Members
Assembly: Alachisoft.NCache.Runtime.dll
Syntax
[Serializable]
public sealed class OracleCacheDependency : CacheDependency, IDisposable, IBinaryProtocolSerializable
Remarks
You can add items with dependencies to your application's cache with the Add, Insert or AddDependency methods.
When you add an item to an application's cache 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 to avoid losing changes made to the object between the time it is created and the
time it is inserted into the cache.
OracleCacheDependency class supports the association of cached items with an
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 the dependency. |
System.String | cmdText | SQL statement, table name or stored procedure to execute on the data source. |
Remarks
This constructor is used to create OracleCacheDependency objects which use the query-notification feature of Oracle products.
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 statement must refer to "dbo.customers".
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 | SQL statement, table name or stored procedure to execute on the data source. |
OracleCommandType | cmdType | The type of the command (text/stored procedures). |
System.Collections.Generic.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 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 statement must refer to "dbo.customers".
Properties
CommandParams
Describes the type of the parameters passed to the Oracle command.
Declaration
public Dictionary<string, OracleCmdParams> CommandParams { get; set; }
Property Value
Type | Description |
---|---|
System.Collections.Generic.Dictionary<System.String, OracleCmdParams> |
CommandText
CommandText to be used by the dependency.
Declaration
public string CommandText { get; set; }
Property Value
Type | Description |
---|---|
System.String | CommandText to be used by the dependency. |
CommandType
Describes the type of the Oracle command passed to the OracleDependency.
Declaration
public CommandType CommandType { get; set; }
Property Value
Type | Description |
---|---|
System.Data.CommandType | The type and value of the parameters passed to the command instance. |
ConnectionString
Connection String that is required by the cache in order to connect with database.
Declaration
public string ConnectionString { get; set; }
Property Value
Type | Description |
---|---|
System.String | Connection String that is required by the cache in order to connect with database |