EF Code First Project Doesn't Create AspNetUsers, AspNetRoles etc Tables after changing DB Connection

Question

I've finished an EF Code First Project with a SQL Express database in a lab environment.

Once the project is done, I've changed the DB Connection String to connect to the new Production SQL Express Database.

Now, I have got the Model tables generated automatically but the AspNetUsers, AspNetRoles, AspNetUserRoles etc. are not generated automatically. I am a new learner and I need your help to know how I can get the tables back in the database.

If I do update-database from the Package Manager Console, I get:

Error Number:4902,State:1,Class:16
Cannot find the object "dbo.AspNetUsers" because it does not exist or you do not have permissions.

And also if you could explain to me how the migration works for Identity tables?

Tonmoy · Accepted Answer · 2017-06-01 05:03:01Z

6

1) Took backup of all my work

2) Deleted Migration Folder

3) Using SQL Management Studio, From the Production Server, Deleted the Database

4) From Package Manager Console

Enable-Migrations -Force
Add-Migration init
Update-Database

You know what, all the tables are back on production database now :-) Thanks to Lin from How to re-create database for Entity Framework?

Hopefully this question/answer will help someone else like me

answered Jun 1, 2017 at 5:03

Tonmoy

2,0382 gold badges12 silver badges17 bronze badges

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

1 Comment

Mohammad Taherian Over a year ago

Thanks for the answer. Just as a comment, Enable-Migrations is now obsolete in EF Core. just start with Add-Migration

yoo · Accepted Answer · 2019-02-14 19:01:49Z

0

Take a backup. Delete migration folder. Delete db. open package manager console > type Add-Migration "initail migration" > hit enter > type update-Database then you good to go.

answered Feb 14, 2019 at 19:01

yoo

211 silver badge3 bronze badges

Comments

YManaf · Accepted Answer · 2019-03-04 20:16:46Z

0

Instead of deleting the Database, you can delete only these tables:

__MigrationHistory, AspNetRoles, AspNetUserClaims, AspNetUserLogins, AspNetUserRoles

then delete the Migration folder and finaly from you PM console:

Enable-Migrations -Force
Add-Migration InitialCreate
Update-Database

answered Mar 4, 2019 at 20:16

YManaf

613 bronze badges

Collectives™ on Stack Overflow

EF Code First Project Doesn't Create AspNetUsers, AspNetRoles etc Tables after changing DB Connection

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related