it:ad:code_first:migrations:howto:coded_migration_examples:add_remove_alter_column

IT:AD:EF/CodeFirst/Migrations:HowTo:Coded Migration Examples/Add/Remove/Alter/Column


    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

public override void Up()
{
    RenameColumn(table: "dbo.MyTypes", 
                 name: "SaleZipCodeId", newName: "ZipCodeId");
}

public override void Down()
{
    RenameColumn(table: "dbo.MyTypes", 
                 name: "ZipCodeId", newName: "SaleZipCodeId");
}

  • /home/skysigal/public_html/data/pages/it/ad/code_first/migrations/howto/coded_migration_examples/add_remove_alter_column.txt
  • Last modified: 2023/11/04 02:45
  • by 127.0.0.1