Imagine that you’ve created a Primary Key in Entity Framework (AFAIK, this applies to EF Core and EF 6), and it’s the wrong type: perhaps you created it as a Guid and decided it should be a string; obviously, if you created it as a string and you want it as an integer, then you have the same issue you have with any such change: EF doesn’t know how to change the text “Donald” into an integer any more than you do !
Imagine you have a primary key PK_Duck on the table: Duck. The table has the following data:
White with a blue coat
White with a bonnet and shawl
If you just change the model / entity type from a Guid to a string, EF will generate something like the following migration:
migrationBuilder.AlterColumn<string>( name: "Id", table: "Duck", nullable: false, oldClrType: typeof(Guid));
If you try to update the DB, you’ll get the following error:
The object ‘PK_Duck’ is dependent on column ‘Id’. ALTER TABLE ALTER COLUMN Id failed because one or more objects access this column.
The solution here is actually quite straightforward, and exactly what you would do in raw SQL; you just drop the primary key. Manually change the migration to drop the key first, and then re-create it afterwards:
migrationBuilder.DropPrimaryKey("PK\_Duck", "Duck"); migrationBuilder.AlterColumn<string>( name: "Id", table: "Duck", nullable: false, oldClrType: typeof(Guid)); migrationBuilder.AddPrimaryKey("PK\_Duck", "Duck", "Id");