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