Change Database during runtime in Entity Framework, without changing the Connection

asp.net-web-api c# entity-framework sql-server

Question

I want to start using Entity Framework in our upcoming release and I have a server that hosts 50 databases with identical schemas.

For each of those databases, I don't require a new connection. For data management and speed (this is a WebAPI application), I don't want to create a new EF context every time I communicate to one of the 50 databases if I don't have to. Unless, of course, if this occurs each time a request is sent to the server, in which case there is no great concern.

The only thing I actually require is the capacity to modify the USE [databasename] instruction, which, I presume, finally makes its way from EF to the server.

Is it possible to complete this in code? Does EF keep track of a read/write property in the context for the database name, which might be modified instantly before executing SaveChanges(), etc.?

Thanks a lot!

bob

1
20
9/17/2013 4:09:29 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

You may like to review:

  • Regarding sending an existing SQL Connection to the EntityFramework Context, Why query
  • Also describing how to modify the database on an existing connection at this piece.

If you require any extra assistance, kindly let me know.

Edited
Link 2 has been updated to refer to the SqlConnection.ChangeDatabase approach.
Thus, code would eventually like the following:

MetadataWorkspace workspace = new MetadataWorkspace(
  new string[] { "res://*/" }, 
  new Assembly[] { Assembly.GetExecutingAssembly() });

using (SqlConnection sqlConnection = new SqlConnection(connectionString))
using (EntityConnection entityConnection = new EntityConnection(workspace, sqlConnection))
using (NorthwindEntities context = new NorthwindEntities(entityConnection))
{
  // do whatever on default database
  foreach (var product in context.Products)
  {
    Console.WriteLine(product.ProductName);
  }

  // switch database
  sqlConnection.ChangeDatabase("Northwind");
  Console.WriteLine("Database: {0}", connection.Database);
}
4
5/23/2017 10:31:22 AM

Popular Answer

Work smart, not hard, please!!!

MYContext localhostContext = new MYContext();
MYContext LiveContext = new MYContext();
//If your databases in different servers
LiveContext.Database.Connection.ConnectionString = LiveContext.Database.Connection.ConnectionString.Replace("localhost", "Live");
//If your databases have different Names
LiveContext.Database.Connection.ConnectionString = LiveContext.Database.Connection.ConnectionString.Replace("DBName-Localhost", "DBName-Live");

databases should all have the same structure.

Zeyad Qunees

Related Questions

How can I alter the Entity Framework database schema (mysql database)?

In a project, I use EntityFramework to establish a connection to a MySQL database. Devart Dot.connect is the service provider....The user must provide connection parameters during runtime for this program to connect to a database. Of course, the name of the MySQL database is included....I built and stored the custom connexion parameters using the E...
c# connection database entity-framework mysql
asked by pierre

Change the database name in the connection string in Entity Framework during runtime.

I want to run some unit tests on the EntityFramework-using DAL layer in my project. Before each test run, I build a fresh database from scratch (in order to have always the same initial data when doing the tests). This database is deleted at the conclusion of the tests; this is done automatically with the aid of the [ClassInitialize()] and [ClassCl...
.net entity-framework runtime
asked by Lucian

Change the database schema of Entity Framework during runtime.

The connection string may be changed at runtime in the majority of ASP.NET apps to change the database store. I.e., by just altering the value of the "database" column in the connectionstring, I may go from utilizing a test database to a production database....With entity framework, I'm attempting to modify the schema but not necessarily the databa...
asp.net c# entity-framework
asked by user48545

Entity Framework change connection at runtime

I realize I'm a little late with this response, but I believe there may be a clever extension method that could help. With a few little framework calls and the EF convention over configuration, we can benefit....The commented code and example usage are as follows:...class of extension methods:...public static class ConnectionTools { // all para...
asp.net-web-api c# connection-string entity-framework
asked by jim tollan

Change DbContext connection at run-time

I want to collaborate with DBs A, B, and C. Everybody uses the same tables (for example: users, products)....I want to leave it up to the user to select the database he wishes to use (at runtime). Therefore, I generated the ADBEntities, BDBEntities, and CDBEntities classes using EF5 and three edbx files....How can I allow him to select the database...
c# database entity entity-framework reflection
asked by user3017270

Entity Framework 6.0 not auto-generating 'On Changing' or 'On Change' partial methods for table fields

I am using a SQL Server dataset to generate entity foundation classes. However, I do not see the partial methods as shown in the following example:...partial void OnFirstNameChanging(global::System.String value); partial void OnFirstNameChanged(); ...I'm using EF6.0 and VS2012. In numerous online examples, it is discussed how to add validation logi...
entity-framework-6
asked by Flintlock Wood

Entity Framework change connection at runtime

I realize I'm a little late with this response, but I believe there may be a clever extension method that could help. With a few little framework calls and the EF convention over configuration, we can benefit....The commented code and example usage are as follows:...class of extension methods:...public static class ConnectionTools { // all para...
asp.net-web-api c# connection-string entity-framework
asked by jim tollan

Entity Framework : Change connection string at runtime

ZZZ_tmp
asp.net-mvc c# dependency-injection entity-framework structuremap
asked by Shahin

c# - Entity Framework ConnectionString won't update after changing App.Config in runtime

I'm working on a WPF application that uses Entity Framework to access data. I must first update the app after creating a new connection string based on the user's input. Set up in accordance with that....The issue is that Entity Framework still utilizes the outdated startup-time ConnectionString for creating the DbContext after changing the App.Con...
app-config c# connection-string entity-framework entity-framework-6
asked by evolon

Track changes to collections using Entity Framework change tracker

I use the Entity Framework change tracker to identify what has changed before writing modifications and to serialize the changes for auditing and history purposes. Calling will get me the updated entities....this.ChangeTracker.Entries()... in my...DbContext... looking at the values for anything indicated with a derivative...EntityState.Added... , ....
c# entity-framework entity-framework-6
asked by Casey

How to add new entity properties in Entity Framework without changing database model

ZZZ_tmp
asp.net-mvc c# entity-framework entity-framework-6
asked by anu

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow