How to use one database in two .Net core MVC and Web API projects?

Question

I've create two MVC and Web API .Net Core projects in one solution, in first project i've added model Phone and DataContext for it, made migration and update-database. In second project i've added equals connectionstring,model and DataContext, but when i try make the update-database i get the next error:

There is already an object named 'Phones' in the database.

Tell me please the right way how to configure database, datacontext and models in two projects to use one database ?

CodeCaster · Accepted Answer · 2017-06-16 18:56:32Z

4

If you use two separate DbContexts, each with their own migrations, they'll consider the database to be theirs and reapply the changes that the other project already did, resulting in conflicts such as the one you observed.

Simply move the Entity Framework code into a shared class library and reference that library from both implementing projects, so all state about the database is shared.

answered Jun 16, 2017 at 18:56

CodeCaster

153k24 gold badges237 silver badges287 bronze badges

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

Collectives™ on Stack Overflow

How to use one database in two .Net core MVC and Web API projects?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related