Change database runtime when using ADO.Net

EntityFramework will not allow you to change database, so if you want to change the database at any point of time, you have to use the underlying StoreProvider's Changedatabse method, the extension method looks like :



public static void ChangeDatabase(this ObjectContext context, string databaseName)
{

DbConnection connection =((EntityConnection)context.Connection).StoreConnection;

if(connection.State != ConnectionState.Open)
{
connection.Open();
}

connection.ChangeDatabase(databaseName);
}

Please Like and Share the Blog, if you find it interesting and helpful.

Related articles

• CodeLens : Visual Studio 2013 Feature 
• Print Screen in Asp Net Web Application 
• Error when "git push" : src refspec test does not match any 
• Asp.Net : How to regenerate .designer.cs file for aspx or ascx files 
• Asp Net Interview Questions and Answers - Part 1 
• Three dots(...) in Nodejs 
• Integrate Colorbox in Asp Net Web Application 
• C# : Cannot obtain value of local or argument as it is not available at this instruction pointer 
• How to Integrate CKEditor in Asp Net Web Application 
• Definition of Common Type Specification (CTS) and Common Language Specifications (CLS)