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. Or stackoverflow.com/q/7599455/861716. Or stackoverflow.com/q/12284291/861716. — Gert Arnold
– Gert Arnold, Commented May 17, 2013 at 18:22

Kenneth · Accepted Answer · 2013-05-17 22:00:06Z

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, 2013 at 22:00

Kenneth

28.8k7 gold badges65 silver badges85 bronze badges

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

Comments

phil soady · Accepted Answer · 2013-05-19 13:45:59Z

0

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) { }

answered May 19, 2013 at 13:45

phil soady

11.4k5 gold badges55 silver badges100 bronze badges

Collectives™ on Stack Overflow

Entity Framework 5 multiple databases

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related