protected virtual void WriteAddForeignKeyReference(string fromTableName, SqlForeignKey foreignKey, StringBuilder writer)
{
writer.Append("ALTER TABLE ");
WriteTableName(fromTableName, writer);
writer.Append(" ADD CONSTRAINT ");
WriteColumnName(foreignKey.Name, writer); // NOTE: not a column name
writer.Append(" FOREIGN KEY (");
WriteColumnNames(foreignKey.Columns, writer);
writer.Append(") REFERENCES ");
WriteTableName(foreignKey.ReferenceTableName, writer);
writer.Append(" (");
WriteColumnNames(foreignKey.ReferenceColumns, writer);
writer.Append(") ");
}
protected virtual void WriteAddForeignKey(string fromTableName, SqlForeignKey foreignKey, StringBuilder writer)
{
WriteAddForeignKeyReference(fromTableName, foreignKey, writer);
WriteAddForeignKeyOn(writer);
}