Set dynamic ConnectionString Entity Framework

Question

I developed Asp.net application with Entity Framework and now i need to change entity connection string at run time.I tried following way.

public class DataLayer(){

static DataLayer()
{
((EntityConnection)_dbEntity.Connection).StoreConnection.ConnectionString =    GetConnectionString();

//GetConnectonString() returns "user id=xxxx;password=xxxx;database=xxxx;server=xxx.xxx.xx.xx"
}

static DBContext _dbEntity = new DBContext();
//other codes
}

And I checked following links too.Still I couldn't change it.

http://msdn.microsoft.com/en-us/library/bb738533(v=vs.90).aspx

http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/8a89a728-6c8d-4734-98cb-11b196ba11fd

Static context in ASP.NET application = failure.

Ladislav Mrnka
– Ladislav Mrnka

2012-07-16 08:12:47 +00:00
Commented Jul 16, 2012 at 8:12 — Ladislav Mrnka
– Ladislav Mrnka, Commented Jul 16, 2012 at 8:12
i changed that one still i cant change it.

LittleOne
– LittleOne

2012-07-16 08:36:20 +00:00
Commented Jul 16, 2012 at 8:36 — LittleOne
– LittleOne, Commented Jul 16, 2012 at 8:36

Ladislav Mrnka · Accepted Answer · 2012-07-16 08:15:31Z

2

You cannot change connection string of existing context. If you want to control connection string at runtime you must pass connection string to DbContext or ObjectContext constructor.

Btw. as I already mentioned in comment - you must not use static context in ASP.NET. You should never use static context at all. Your application will not work correctly if you will continue with static context.

answered Jul 16, 2012 at 8:15

Ladislav Mrnka

365k60 gold badges666 silver badges673 bronze badges

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

2 Comments

LittleOne Over a year ago

Yep i tried that one too. I got following error. "Keyword not supported: 'user id'." It means connection string is not supported for entityconnection.I tried above links in question too for that.

Ladislav Mrnka Over a year ago

If you are using EDMX you must use valid entity connection string format. What you are passing is not entity connection string format.

LittleOne · Accepted Answer · 2012-07-16 09:13:19Z

0

Finally I got answer.I apply this dbcontext to a Entity datasource of a grid.So it create context at runtime it was fixed.So I changed that one.

 protected void EntityDataSource1_ContextCreating(object sender, EntityDataSourceContextCreatingEventArgs e)
    {
        var dp=new DBContext();
        e.Context = dp;
    }

answered Jul 16, 2012 at 9:13

LittleOne

1311 gold badge4 silver badges16 bronze badges

Collectives™ on Stack Overflow

Set dynamic ConnectionString Entity Framework

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related