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;
}
