EF Code First "String or binary would be truncated" when running Update-Database

Question

My Migration looks like this:

    public override void Up()
    {
        AddColumn("dbo.TargetTable", "Table1Id", c => c.Int(nullable: false));
        AddForeignKey("dbo.TargetTable", "Table1Id", "dbo.Table1", "Id");

        AddColumn("dbo.TargetTable", "Table2Id", c => c.Int(nullable: false));
        AddForeignKey("dbo.TargetTable", "Table2Id", "dbo.Table2", "Id");
    }

    public override void Down()
    {
        DropForeignKey("dbo.TargetTable", "Table1Id", "dbo.Table1", "Id");
        DropColumn("dbo.TargetTable", "Table1Id", c => c.Int(nullable: false));

        DropForeignKey("dbo.TargetTable", "Table2Id", "dbo.Table2", "Id");
        DropColumn("dbo.TargetTable", "Table2Id", c => c.Int(nullable: false));

    }

and when I run "Update-Database" I'm getting the error: String or binary data would be truncated. The statement has been terminated.

I'm not creating any tables, just adding two columns to an existing table. So I am unsure where this error could be coming from. I'm not manipulating any string or binary columns. Any help would be much appreciated.

Edit

The table is empty. It has no rows, that's why the columns are fine being non-nullable.

The Model:

 public class TargetTable
{
    //This column already exists.
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int Id { get; set; }

    public int Table1Id { get; set; }
    public virtual Table1 Table1 { get; set; }

    public int Table2Id { get; set; }
    public virtual Table2 Table2 { get; set; }
}

Can you post your model?

kamil-mrzyglod
– kamil-mrzyglod

2015-06-26 10:57:52 +00:00
Commented Jun 26, 2015 at 10:57 — kamil-mrzyglod
– kamil-mrzyglod, Commented Jun 26, 2015 at 10:57

Alexander Polyankin · Accepted Answer · 2015-06-26 10:26:24Z

1

You are inserting not nullable fields into existing table. If table contains rows, it will cause error.

answered Jun 26, 2015 at 10:26

Alexander Polyankin

1,9421 gold badge17 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Hugh · Accepted Answer · 2015-06-26 10:29:53Z

0

Make sure the types on the column and foreign key are the same type

answered Jun 26, 2015 at 10:29

Hugh

4543 silver badges13 bronze badges

2 Comments

ThomasG Over a year ago

They are, the "Id" columns are integers.

Hugh Over a year ago

Do you have any triggers on the table?

Collectives™ on Stack Overflow

EF Code First "String or binary would be truncated" when running Update-Database

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related