Two DB(SQL Server and Sqlite) in Entity Framework Project.

Question

Currently, I am working with Asp.Net Windows application. I am using two databases(SQL Server and Sqlite) in my application.

Now I want to move into Entity Framework. If I use Database First approach then I have to specify the Database. I could not understand that how to use both database in Entity Framework.

If it is not possible then Is there any other approach ?

Rajkiran Swain · Answer

http://www.entityframeworktutorial.net/database-first-with-entity-framework.aspx   https://www.simple-talk.com/dotnet/net-framework/using-entity-framework-with-an-existing-database-data-access/

Vivek Kumar · Answer

Yes, It is possible. Have a look into below links.   https://stackoverflow.com/questions/20308378/configure-multiple-database-entity-framework-6   https://www.codeproject.com/Tips/1062375/Entity-Framework-Multi-DB-Support

Nilesh Shah · Answer

It's possible and I have used more than one DB in EF   you will need to have separate edmx file for each DB