4

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
  • 2,008
  • 2
  • 10
  • 16

3 Answers3

5

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

Tonmoy
  • 2,008
  • 2
  • 10
  • 16
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.

yoo
  • 21
  • 1
  • 3
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
YManaf
  • 61
  • 3