protected abstract void Generate(AddFKConstraint op);
protected override void Generate(AddFKConstraint op) { using (var sql = this.Writer()) { sql.Write(@" ALTER TABLE "); sql.Write(this.Quote(op.DependentTable)); sql.Write(@" ADD CONSTRAINT "); sql.Write(this.Quote(op.ConstraintName)); sql.Write(@" FOREIGN KEY ("); sql.Write(this.Quote(op.DependentTableColumn)); sql.Write(") REFERENCES "); sql.Write(this.Quote(op.PrincipleTable)); sql.Write("("); sql.Write(this.Quote(op.PrincipleTableColumn)); sql.Write(")"); if (op.NeedDeleteCascade) { sql.Write(" ON DELETE CASCADE"); } this.AddRun(sql); } }
protected override void Generate(AddFKConstraint op) { var oldName = op.ConstraintName; PrepareFKConstraintName(op); base.Generate(op); op.ConstraintName = oldName; }