// Add trigger public override string GetCreateTriggerSql(string tableName, string triggerName, TriggerTiming timing, TriggerEvents events, string body) { return("CREATE OR REPLACE TRIGGER " + QuoteSchemaIdentifier(triggerName) + "\n" + " " + timing.ToSql() + " " + events.ToSql() + " ON " + QuoteSchemaIdentifier(tableName) + " FOR EACH ROW\n" + " BEGIN\n" + body + " END;"); }
// Add Trigger public virtual string GetCreateTriggerSql(string tableName, string triggerName, TriggerTiming timing, TriggerEvents events, string body) { return("CREATE TRIGGER " + QuoteSchemaIdentifier(triggerName) + " ON " + QuoteSchemaIdentifier(tableName) + " " + timing.ToSql() + " " + events.ToSql() + " AS BEGIN\r\n" + body + "\r\nEND;\r\n"); }