Exemplo n.º 1
0
        public bool NeedToCreateTrigger(DbTriggerType type)
        {
            var updTriggerName = this.oracleObjectNames.GetCommandName(DbCommandType.UpdateTrigger);
            var delTriggerName = this.oracleObjectNames.GetCommandName(DbCommandType.DeleteTrigger);
            var insTriggerName = this.oracleObjectNames.GetCommandName(DbCommandType.InsertTrigger);

            string triggerName = string.Empty;

            switch (type)
            {
            case DbTriggerType.Insert:
            {
                triggerName = insTriggerName;
                break;
            }

            case DbTriggerType.Update:
            {
                triggerName = updTriggerName;
                break;
            }

            case DbTriggerType.Delete:
            {
                triggerName = delTriggerName;
                break;
            }
            }

            return(!OracleManagementUtils.TriggerExists(connection, transaction, triggerName));
        }