public virtual string CreatePrimaryKey(PrimaryKeyNew primaryKeyNew)
{
// TODO asc desc in MsSql
var pkColumnsList = primaryKeyNew.PrimaryKey.SqlColumns.ConvertAll(c => "\"" + c.SqlColumn.Name + "\"");
var pkColumns = string.Join(", ", pkColumnsList);
return($"ALTER TABLE {Generator.GetSimplifiedSchemaAndTableName(primaryKeyNew.PrimaryKey.SqlTable.SchemaAndTableName)} ADD CONSTRAINT {primaryKeyNew.PrimaryKey.Name} PRIMARY KEY ({pkColumns})");
}
public void NewPrimaryKey(PrimaryKeyNew primaryKeyNew)
{
var sql = MigrationGenerator.CreatePrimaryKey(primaryKeyNew);
Executer.ExecuteNonQuery(sql);
}
