IT:AD:EF/CodeFirst/Migrations:HowTo:Coded Migration Examples/Add/Remove/Alter/Column
Summary
Examples
public partial class LibHelpEntry01 : DbMigration
{
public override void Up()
{
AddColumn("dbo.XActLib_ApplicationHostSettings", "RenderMethodHints", c => c.String());
AddColumn("dbo.XActLib_HelpEntry", "Order", c => c.Int(nullable: false));
AlterColumn("dbo.XActLib_Resource", "Key", c => c.String(nullable: false, maxLength: 256));
}
public override void Down()
{
AlterColumn("dbo.XActLib_Resource", "Key", c => c.String(nullable: false, maxLength: 128));
DropColumn("dbo.XActLib_HelpEntry", "Order");
DropColumn("dbo.XActLib_ApplicationHostSettings", "RenderMethodHints");
}
Notice that actions are laid out reverse order in the Drop
Rename Columns
public override void Up()
{
RenameColumn(table: "dbo.MyTypes",
name: "SaleZipCodeId", newName: "ZipCodeId");
}
public override void Down()
{
RenameColumn(table: "dbo.MyTypes",
name: "ZipCodeId", newName: "SaleZipCodeId");
}