C# (CSharp) AdminQuery.CreateProcedureTrigger Examples

Example #1

        public void ProcedureTrigger()
        {
            var triggerName = new ObjectName("trigger1");
            var tableName   = ObjectName.Parse("APP.test_table");
            var procName    = new ObjectName("proc1");

            AdminQuery.CreateProcedureTrigger(triggerName, tableName, procName, TriggerEventTime.After, TriggerEventType.Insert);

            var exists = AdminQuery.Access().TriggerExists(ObjectName.Parse("APP.trigger1"));

            Assert.IsTrue(exists);
        }