public partial class MyMigration : Migration
{
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.CreateTable(
name: "MyTable",
columns: table => new
{
Id = table.Column(nullable: false),
Name = table.Column(nullable: false),
DateCreated = table.Column(nullable: false),
},
constraints: table =>
{
table.PrimaryKey("PK_MyTable", x => x.Id);
});
}
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropTable(
name: "MyTable");
}
}
public partial class MyMigration : Migration
{
protected override void Up(MigrationBuilder migrationBuilder)
{
migrationBuilder.AddColumn(
name: "Description",
table: "MyTable",
nullable: true);
}
protected override void Down(MigrationBuilder migrationBuilder)
{
migrationBuilder.DropColumn(
name: "Description",
table: "MyTable");
}
}
This code demonstrates how to modify an existing database table using MigrationBuilder. The `AddColumn` method is used to add a new column to the table.
Package library: Microsoft.EntityFrameworkCore
Overall, MigrationBuilder is a useful class for managing database migrations in code and is commonly used in conjunction with the Entity Framework Core library.var entityBuilder = new [Module] EntityBuilder(migrationBuilder, ActiveDatabase);
InsertSeasonsFromList(migrationBuilder, leagueId, leagueName, startDate, finishDate, query);
InsertLeagueFromList(migrationBuilder, leagueId, leagueName, kv.Item1, kv.Item2, query);
