public static Dictionary <string, TableEntity.Trigger> GetTriggerByTable(string tableName)
{
Dictionary <string, TableEntity.Trigger> triggerDictionary = new Dictionary <string, TableEntity.Trigger>();
System.Data.DataTable triggerDataTable = OracleDocument.GetTriggerByTableName(tableName);
foreach (System.Data.DataRow dataRow in triggerDataTable.Rows)
{//a.table_name,a.trigger_name,a.table_owner,a.triggering_event,a.trigger_body
TableEntity.Trigger trigger = new TableEntity.Trigger();
trigger.TriggerName = dataRow["trigger_name"].ToString();
trigger.TriggeringEvent = dataRow["triggering_event"].ToString();
trigger.TriggerBody = dataRow["trigger_body"].ToString();
trigger.ColumnName = dataRow["column_name"].ToString();
triggerDictionary.Add(trigger.TriggerName, trigger);
}
return(triggerDictionary);
}
