Multiple databases in single Entity Framework application

Question

How can I switch between multiple databases using Entity Framework.
The name of the databases will be coming in a drop down list and on selecting the dropdown list item I need to connect to that particular database using Entity Framework.
What is the best solution? Do EF provide any configuration for achieving this? How should the application be configured?

Answer 1

Hi,

Setting up connection string runtime to the context you can achieve this

Please refer
http://www.codeproject.com/Tips/234677/Set-the-connection-string-for-Entity-Framework-at
http://www.programmersranch.com/2013/11/c-ef-setting-connection-strings-at.html

hope this will help you.