Entity Framework 5 multiple databases

Question

I am totally new to developing technology ASP.NET MVC + Entity Framework 4 5 (DataBase First). I'm in a problem that even after hours of research I have not found a solution.

On my application need that each client has their own database, which will be selected after login.

Create a mapping (edmx) for each base? I have to change the DbContext or connection string lasts execution?

I have no idea where to start. Can I create a mapping (edmx) for each database and change DbContext or connection string in runtime?

Thanks All.

possible duplicate of [Pass connection string to code-first DbContext](http://stackoverflow.com/questions/4805094/pass-connection-string-to-code-first-dbcontext). Or http://stackoverflow.com/q/7599455/861716. Or http://stackoverflow.com/q/12284291/861716. — Gert Arnold, May 17 '13 at 18:22

score 0 · Accepted Answer · answered May 17 '13 at 22:00

0

When you're creating your DbContext you can just pass in the name of connectionstring in your web.config:

var db = new MyDbContext("NameOfConnectionStringInWebConfig");

answered May 17 '13 at 22:00

Kenneth

28,294
6
61
84

score 0 · Answer 2 · answered May 19 '13 at 13:45

You can pass a connection string Name, or Db Connection details (SqlConnection) If you have a multi DB concept where the the DBs are added at runtime, the DB Connection approach is useful since the App.config doesnt have the connection Name.

You can of course add the connection names to app.config, or try the DB connection approach. it gets fun to get that working when you get to the migration topic.

public class MyDbContext : DbContext  
//ctor
    public MyDbContext(string connectionName) : base(connectionName){  }

    public MyDbContext(DbConnection dbConnection, bool contextOwnsConnection)
        : base(dbConnection, contextOwnsConnection) { }

Entity Framework 5 multiple databases

2 Answers2