Entity Framework Error String or binary data would be truncated in table

Question

I am making a tweak to my table.

The scaffold is pretty straight forward, it's limiting the number of characters for some string columns.

I am presented with this error

String or binary data would be truncated in table '', column 'DetailedDescription'. Truncated value: ''

I tried to do an update-database -force and it still won't let me

Migration Details

AddColumn("dbo.Tests", "AdditionalInstructions", c => c.String(maxLength: 2000));
AlterColumn("dbo.Tests", "DetailedDescription", c => c.String(maxLength: 500));
AlterColumn("dbo.Tests", "VenueName", c => c.String(maxLength: 100));

Hadi Samadzad · Accepted Answer · 2020-04-30 02:54:50Z

1

If you are applying a migration on an existing table that has some rows, the "String or binary data would be truncated in table" error means currently you have a stored string in the "DetailedDescription" column which its length is more than 500 characters. So, you should handle these values and try to run the update-database command again.

answered Apr 30, 2020 at 2:54

Hadi Samadzad

1,5512 gold badges17 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

Entity Framework Error String or binary data would be truncated in table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related