Entity Framework database first and dynamic connection string for 100+ SQL Server databases

Question

I am new to Entity Framework and want to know how to modify the connection string in code.

Here is my code

using (var context = new PushjobModel.PushjobEntities())
{
    var list = context.GetAllActivePushjobs();

    foreach (PushjobModel.Pushjob item in list)
    {
        item.IsActive = false;
        item.IsSent = true;
    }

    context.SaveChanges();
}

I have a configuration file in my ASP.NET webforms application which contains a list of connection strings for 100+ databases. Before I call context.GetAllActivePushjobs(); I want to change the connection string.

With old ADO.NET I have been using following approach for long time and it works perfectly

spPremisesReadTableAdapter taPremises = new spPremisesReadTableAdapter();

taPremises.Connection.ConnectionString = GetConnectionString(CompanyName);

taPremises.GetData();
...

public static void GetConnectionString(string CompanyName)
{
    string connectionstring = System.Web.Configuration.WebConfigurationManager.ConnectionStrings[CompanyName].ConnectionString;
}

Can anyone help?

possible duplicate of Set Entity Framework Connection String at Runtime in C# — kjbartel
– kjbartel, Commented Feb 20, 2015 at 9:38

Maziar Taheri · Accepted Answer · 2015-02-20 09:25:02Z

1

I think what you are looking for is the class EntityFrameworkConnectionStringBuilder

Take a look at MSDN page

answered Feb 20, 2015 at 9:25

Maziar Taheri

2,33822 silver badges29 bronze badges

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

Comments

marc_s · Accepted Answer · 2015-02-20 09:19:33Z

0

You just need to provide the name of the connection string entry to your constructor of your DbContext:

using (var context = new PushjobModel.PushjobEntities(name-of-connection-string-here))
{
   .....
}

answered Feb 20, 2015 at 9:19

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

2 Comments

3355307 Over a year ago

Thanks. I created another connection string on the pattern of entity framework and it worked

3355307 Over a year ago

existing connection strings in config file in the format <add name="test100" connectionString="data source=(local);initial catalog=TestXYZ100;Integrated Security=True""></add> is there any way so that I can pass this connection string and its converted into entity framework style connection string because I have to create duplicate connection string now one for old ado.net connectivity and otherone for entity framework connectivity

beastieboy · Accepted Answer · 2015-02-20 10:26:15Z

0

May be you could try this:

using (var context = new PushjobModel.PushjobEntities(GetConnectionString(CompanyName)))
{
    var list = context.GetAllActivePushjobs();

    foreach (PushjobModel.Pushjob item in list)
    {
        item.IsActive = false;
        item.IsSent = true;
    }

    context.SaveChanges();
}

public static void GetConnectionString(string CompanyName)
{
    string connectionstring = System.Web.Configuration.WebConfigurationManager.ConnectionStrings[CompanyName].ConnectionString;
}

answered Feb 20, 2015 at 10:26

beastieboy

8838 silver badges15 bronze badges

Collectives™ on Stack Overflow

Entity Framework database first and dynamic connection string for 100+ SQL Server databases

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related