Constructor OracleCacheDependency

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".