Reverting migration that adds column with default value throws

[mikary]

When attempting to revert a migration that adds an int column with a default value, migrations throws a SqlException.

Migration code:

    public partial class AddValue : Migration
    {
        public override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.AddColumn("MyData", "Value", c => c.Int(nullable: false, defaultValue: 2));
        }

        public override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropColumn("MyData", "Value");
        }
    }

Error:

> k ef migration apply 0
Using context 'MyContext'.
Reverting migration '201501021757503_AddValue'.
System.Data.SqlClient.SqlException (0x80131904): The object 'DF__MyData__Value__25869641' is dependent on column 'Value'.
ALTER TABLE DROP COLUMN Value failed because one or more objects access this column.

Script:

> k ef migration script AddValue InitialCreate
Using context 'MyContext'.
ALTER TABLE [MyData] DROP COLUMN [Value]
DELETE FROM [__MigrationHistory] WHERE [MigrationId] = '201501021757503_AddValue' AND [ContextKey] = 'MigrationDownRepro.MyContext'

[mikary]

Added reproduction here:
https://github.com/mikary/EF-Issue-1345

[natemcmaster]

I found a similar bug. Dropping a nvarchar column with a default constraint also fails. I assume it is related to this issue.

[bricelam]

Yep, SQL Server is silly and requires you to manually drop DEFAULT "constraints". I interpret this issue to mean handling it in general.