private string GenerateSqlStatementConcrete(AddForeignKeyOperation migrationOperation) { DB2DdlBuilder ddlBuilder = new DB2DdlBuilder(); ddlBuilder.AppendSql("ALTER TABLE "); ddlBuilder.AppendIdentifier(migrationOperation.DependentTable); ddlBuilder.AppendSql(" ADD CONSTRAINT "); ddlBuilder.AppendIdentifier(migrationOperation.Name.Replace("dbo.", "")); ddlBuilder.AppendSql(" FOREIGN KEY ("); ddlBuilder.AppendIdentifierList(migrationOperation.DependentColumns); ddlBuilder.AppendSql(")"); ddlBuilder.AppendSql(" REFERENCES "); ddlBuilder.AppendIdentifier(migrationOperation.PrincipalTable); ddlBuilder.AppendSql(" ("); ddlBuilder.AppendIdentifierList(migrationOperation.PrincipalColumns); ddlBuilder.AppendSql(")"); if (migrationOperation.CascadeDelete) { ddlBuilder.AppendSql(" ON DELETE CASCADE "); } return(ddlBuilder.GetCommandText()); }
private string GenerateSqlStatementConcrete(AddPrimaryKeyOperation migrationOperation) { DB2DdlBuilder ddlBuilder = new DB2DdlBuilder(); ddlBuilder.AppendSql("ALTER TABLE "); ddlBuilder.AppendIdentifier(migrationOperation.Table); ddlBuilder.AppendSql(" ADD CONSTRAINT "); ddlBuilder.AppendIdentifier(migrationOperation.Name.Replace("dbo.", "")); ddlBuilder.AppendSql(" PRIMARY KEY ("); ddlBuilder.AppendIdentifierList(migrationOperation.Columns); ddlBuilder.AppendSql(")"); return(ddlBuilder.GetCommandText()); }
private string GenerateSqlStatementConcrete(CreateIndexOperation migrationOperation) { DB2DdlBuilder ddlBuilder = new DB2DdlBuilder(); ddlBuilder.AppendSql("CREATE "); if (migrationOperation.IsUnique) { ddlBuilder.AppendSql("UNIQUE "); } ddlBuilder.AppendSql("INDEX "); ddlBuilder.AppendIdentifier(migrationOperation.Name); ddlBuilder.AppendSql(" ON "); ddlBuilder.AppendIdentifier(migrationOperation.Table); ddlBuilder.AppendSql(" ("); ddlBuilder.AppendIdentifierList(migrationOperation.Columns); ddlBuilder.AppendSql(")"); return(ddlBuilder.GetCommandText()); }