protected override DbCommand OnBuildCreateRelationCommand(ICreateRelation Query)
{
SqlCommand command;
StringBuilder sql;
sql = new StringBuilder();
sql.Append("ALTER TABLE ");
sql.Append(OnFormatTableName(Query.Table));
sql.Append($" WITH CHECK ADD CONSTRAINT [FK_{Query.ForeignColumn.Table.Name}_{Query.ForeignColumn.Name}_{Query.PrimaryColumn.Table.Name}]");
sql.Append($" FOREIGN KEY ({OnFormatColumnName(Query.ForeignColumn, false)})");
sql.Append($" REFERENCES [{Query.PrimaryColumn.Table.Name}] ({OnFormatColumnName(Query.PrimaryColumn, false)})");
command = new SqlCommand(sql.ToString());
return(command);
}
protected abstract DbCommand OnBuildCreateRelationCommand(ICreateRelation Query);
