Deleted table in database; how to recreate it using Code First

Question

After deleting table X in database, issued update-database command in PackageManagerConsole, and now I get the following error: "Cannot find the object "dbo.X" because it does not exist or you do not have permissions."

Considering this scenario, how to force CodeFirst to create the table from scratch?

either you have to recreate it manually or force EF to initialize the database again, for example using an additional constructor. — DevilSuichiro
– DevilSuichiro, Commented Oct 23, 2015 at 17:23
@DevilSuichiro, does initializing the db again requires drop deleting it first? — usefulBee
– usefulBee, Commented Oct 23, 2015 at 17:27
not if you write your own initializer, however that might be a not as simple task. — DevilSuichiro
– DevilSuichiro, Commented Oct 23, 2015 at 18:23

usefulBee · Accepted Answer · 2015-10-23 19:06:53Z

3

These are the work around steps that deals with this scenario:

delete table from db
delete all related stored procedures if any
create a new imitation entity/table class with a different/distinct name (ex. BlahBlah)
create any configs needed for the new entity inside OnModelCreating method
in the PackageConsoleManager, issue an add-migration command
open the migration file and replace all BlahBlah words with the old table name
Comment or delete the old table class
repeat 7 for old configs in OnModelCreating
rename the new table class with the old table class name
repeat 8 for the new table configs in OnModelCreating
in the PackageConsoleManager, issue an add-migration command again
if it creates a new migration, replace its content with the old migration created in step 6
in the PackageConsoleManager, issue update-database command

answered Oct 23, 2015 at 19:06

usefulBee

9,85610 gold badges57 silver badges97 bronze badges

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

1 Comment

Nikita Over a year ago

After deleting table in db: use ctrl+r, ctrl+r to rename entity, than add-migration, in migration in Up leave createTable, in Down leave dropTable. update-database. One more time add-migration/update-database to set keys. And rename and add;update. This will save correct migrations if you need to rollback.

Collectives™ on Stack Overflow

Deleted table in database; how to recreate it using Code First

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related