public Trigger Build(Trigger trigger) { if (table == null) table = new TableBuilder().Build(); table.Triggers.Add(trigger); trigger.ParentObject = table; trigger.Schema = schema ?? new SchemaBuilder().Build(); trigger.Type = SqlObjectType.SqlDmlTrigger; return trigger; }
public Trigger Build() { var trigger = new Trigger { CreateDate = new DateTime(2010, 6, 15), Definition = "CREATE TRIGGER [dbo].[test_trigger] ON [dbo].[test_table] AFTER INSERT,DELETE AS BEGIN SET NOCOUNT ON; END", Id = -1, IsDisabled = true, IsInsteadOfTrigger = false, IsMsShipped = true, IsNotForReplication = true, IsPublished = true, IsSchemaPublished = true, ModifyDate = new DateTime(2010, 7, 20), Name = "test_trigger", Type = SqlObjectType.SqlDmlTrigger }; return Build(trigger); }