Entity Framework changing database of existing DbContext

Question

If I have the following code (for example, in the constructor of my repository):

var db = new MyDbContext();
var entity = db.Set<Customer>();

Then later I do:

db.Database.Connection.ConnectionString = mySQLconnectionstring;

Do I need to 're-set' the entity?

This is really something you can just try and see if it works. — user247702
– user247702, Commented Nov 28, 2013 at 9:05
I have multiple databases based on the same model, and I want to change the database at a later stage. — Ivan-Mark Debono
– Ivan-Mark Debono, Commented Nov 28, 2013 at 9:06

Dennis · Accepted Answer · 2016-11-12 15:31:23Z

4

Bad idea. You should create new context instance:

var db1 = new MyDbContext("connstr1");
var db2 = new MyDbContext("connstr2");

Otherwise you'll get more difficulties, than benefits you're supposing (if this ever possible). Note, that every context instance keeps local cache of materialized entities and tracks their changes.

Since the model is the same, model building (which is most significant performance hit in EF) will happen just once. I can't imagine, what else could force you to re-use context instances.

edited Nov 12, 2016 at 15:31

answered Nov 28, 2013 at 9:08

Dennis

37.9k11 gold badges87 silver badges158 bronze badges

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

1 Comment

Ivan-Mark Debono Over a year ago

Is the connectionstring passed to the dbcontext an sql connection string or an entity connection string?

dlogon · Accepted Answer · 2018-09-05 18:50:49Z

1

Write new class file and add this method to your context

public partial class YourEntitities
{
    public void SetDatabase(string dataBase)
    {
        string connString = Database.Connection.ConnectionString;
        Regex rgx = new Regex(@"(?<=initial catalog=)\w+");
        string newconnString = rgx.Replace(connString, dataBase);
        //string  = connString.Replace("{database}", dataBase);
        Database.Connection.ConnectionString = newconnString;
    }
}

answered Sep 5, 2018 at 18:50

dlogon

811 silver badge7 bronze badges

Comments

cahit beyaz · Accepted Answer · 2013-11-28 09:25:40Z

if you want to use same context for multiple database, you can do that. one way is changing connection string of context in the memory. before changing db that you want to use. Call this piece of code:

        var connStr="YOUR_NEW_DB_CONNECTION_STRING_HERE";
        var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
        var connectionStringsSection = (ConnectionStringsSection)config.GetSection("connectionStrings");
        connectionStringsSection.ConnectionStrings["YOUR_DB_CONNECTION_STRING_NAME_EG_CONN_STR"].ConnectionString = connStr;
        connectionStringsSection.ConnectionStrings["YOUR_DB_CONNECTION_STRING_NAME_EG_CONN_STR"].ProviderName = "System.Data.EntityClient";
        config.Save();
        ConfigurationManager.RefreshSection("connectionStrings");

Collectives™ on Stack Overflow

Entity Framework changing database of existing DbContext

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related