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