How to solve problem in updating database of sql server in identity asp.net framework

[michaellee7770]

Select Topic Area

Question

Body

Recently I am working on project that have identity asp.net web api as backend and ReactJs as frontend.
I have problem in updating database in backend. and I am using sql server as database.
After changing model in backend, I created migrations for that.
and I run this comment in terminal of vscode.
dotnet ef database update
At that time, in database AspNetUserRoles table content was deleted and AspNetRoles table content was changed.
How can I prevent this problem? Please feel free to reach out me if you have any idea.

[edward7770]

Before I faced this problem when I worked on identity asp.net framework.
I solved this in SQL server management studio. when updating database, I renamed AspNetUserRoles and AspNetUserRole. and then I created
fake AspNetRoles table like real AspNetRoles.
After updating database, I renamed table name again.
You can try that using this way. I think it's not the best way, but it will help you solve that problem.

[michaellee7770]

thanks for your support