How to Change Database on a Entity Framework Connection

Question

I got a ADO.NET Entity Data Model that I want to use on several databases (on the same server), how would you solve it?

// This results in a exception, "Specified method is not supported".
private MyEntities _db = new MyEntities();

public IQueryable<MyObject> GetMyObjects(string database)
{
    _db.Connection.ChangeDatabase(database);

    return _db.MyObjects
}

// This works...
private MyEntities _db;
private string entityConnectionString = ConfigurationManager.ConnectionStrings["MyEntities"].ConnectionString;

public IQueryable<MyObject> GetMyObjects(string database)
{
    _db = new MyEntities(entityConnectionString.Replace("__REPLACE_ME__", database));

    return _db.MyObjects
}

Craig Stuntz · Accepted Answer · 2010-11-02 12:36:52Z

4

I'd probably modify your "This works..." version, something like this::

private MyEntities _db;
private string entityConnectionString = ConfigurationManager.ConnectionStrings["MyEntities"].ConnectionString;

public IQueryable<MyObject> GetMyObjects(string database)
{
    var ecsb = new EntityConnectionStringBuilder(entityConnectionString);
    var scsb = new SqlConnectionStringBuilder(ecsb.ProviderConnectionString)
    scsb.InitialCatalog = database;
    ecsb.ProviderConnectionString = scsb.ToString();
    _db = new MyEntities(ecsb.ToString());    
    return _db.MyObjects
}

edited Nov 2, 2010 at 12:36

answered Nov 1, 2010 at 16:50

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

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

1 Comment

Johan Olsson Over a year ago

Thanks, that solution looks much better. Changed the second line in GetMyObjects to "var scsb = new SqlConnectionStringBuilder(ecsb.ProviderConnectionString);".

Collectives™ on Stack Overflow

How to Change Database on a Entity Framework Connection

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related