This project is read-only.

OracleTableDependency Constructor

Creates a new instance of the OracleTableDependency class.

Syntax

public OracleTableDependency(
   string connectionString, 
   string tableName, 
   ModelToColumnsTableMapper mapper = null, 
   IEnumerable<string> updateOfList = null)

Parameters

connectionString
Type: System.String
ORACLE connection string relative to the database containing the table to monitor.

tableName
Type: System.String
Database table name to monitor.

mapper
Type: ModelToTableMapper (Optional)
Used to specify a mapping between model properties and database table columns name.

updateOfList
Type: IEnumerable<string> (Optional)
Used to define a database table columns list to monitor. Basically this list it used to create the UPDATE OF condition within the table trigger. So, defining this list, you will receive event only when the specified columns have been changed. Is has effects only for UPDATE operations.

tableDependency = new OracleTableDependency<Item>(
   _connectionString, 
   "ARTICLES", 
    updateOfList: new List<string>() { "APPROVED" });

OracleTableDependency's generated trigger:

CREATE OR REPLACE TRIGGER Tr_Product
AFTER UPDATE OF APPROVED ON ARTICLES 
FOR EACH ROW
BEGIN
    ....
END;


Last edited Sep 16, 2015 at 10:33 AM by delbianco, version 10