ALTER TABLE DROP COLUMN failed because column 'xxx' does not exist in table 'yyy'

Question

I make a mistake. I delete some row in table __MigrationHistory in my database.
and now when I run my project I force this error:

ALTER TABLE DROP COLUMN failed because column 'xxx' does not exist in table 'yyy'.

How can I solved this problem?

Answer 1

Add a new migration to re-synchronize:

add-migration MissingXXX -IgnoreChanges // tells EF to just take a snapshot
update-database

Now you are back in sync and can continue with future model changes.

Answer 2

OK, finally I solved my problem.
I added field 'xxx' to table 'yyy' manually in my database.