C# How To Update Entity Model Connection String

Question

This is my first WinForm application using the Entity Framework and I have to be able to update the connection string for the entity model I created on the fly and in my app.config file I have the following connectionString:

<add name="NCIPEntities" connectionString="metadata=res://*/NCIPModel.csdl|res://*/NCIPModel.ssdl|res://*/NCIPModel.msl;provider=System.Data.SQLite;provider connection string='data source=&quot;C:\Test\NCIP\NCIP.db3&quot;;pooling=True'" providerName="System.Data.EntityClient" />

This is what I wrote to update the string on the fly, it doesn't throw any errors when it runs but it also doesn't save the new connection string back to the app.config file.

private void UpdateEntityConnection()
    {
        StringBuilder Sb = new StringBuilder();
        Sb.Append(@"metadata=res://*/NCIPModel.csdl|res://*/NCIPModel.ssdl|res://*/NCIPModel.msl;provider=System.Data.SQLite;provider""");
        Sb.Append("connection string='data source=" + Settings.Default.Directory + "\\NCIP.db3;pooling=True'");

        Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
        config.ConnectionStrings.ConnectionStrings["NCIPEntities"].ConnectionString = Sb.ToString();

        config.Save(ConfigurationSaveMode.Minimal);
        ConfigurationManager.RefreshSection("connectionStrings");
    }

Does anyone see what I am doing wrong because I don't.

Thanks.

Alex James · Accepted Answer · 2009-12-11 16:29:01Z

3

Did you know you can do this:

var connstr = GetConnectionString();

using (NCIPEntities ctx = new NCIPEntities(connstr))
{
    ...
}

I.e. the Entity Framework doesn't have to get the connection string from the App.Config.

Anyway knowing this might change your approach/requirements a little?

Hope this helps

Alex

PS: you might want to check out my Tip 45 for more info. I have a whole series of Tips too

answered Dec 11, 2009 at 16:29

Alex James

20.9k3 gold badges52 silver badges49 bronze badges

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

3 Comments

Nathan Over a year ago

Oh I was under the impression this had to come from the app config file. If this is not the case I can then store the string as a User Setting and then use that instead of the app.config?

Alex James Over a year ago

Absolutely, I had a felling you didn't know this.

Rikin Patel Over a year ago

Is there any way to set one time connection string. i.e. when i call to db then every time i set connection string.

Craig Stuntz · Accepted Answer · 2009-12-11 15:52:16Z

3

You should use EntityConnectionStringBuilder instead of trying to rewrite it. :)

answered Dec 11, 2009 at 15:52

Craig Stuntz

127k12 gold badges257 silver badges275 bronze badges

Comments

Daniel Elliott · Accepted Answer · 2009-12-11 15:53:24Z

0

The article here will help you but ...

From article ... emphasis mine

So here's my take on a convenient little class that allows you to either modify, add or delete any appSettings element, in either your Executable, Console or ASP.NET web application at runtime, on the fly. Bear in mind of course, that if you modify a web.config on a running ASP.NET app, the ASP.NET worker process will recycle. Users currently using your app aren't exactly guaranteed to have a fun experience when this happens...

Kindness,

Dan

answered Dec 11, 2009 at 15:53

Daniel Elliott

22.9k10 gold badges67 silver badges82 bronze badges

Comments

Bill Berlington · Accepted Answer · 2010-11-29 14:18:32Z

0

So I have to initialise NCIPEntities in application start event itself. Right?

But since I to get the database name from the database every time my application restarts, is there a way I can modify the EntityConnectionString and save it back to config file. Just like the SqlConnectionString.InitialCatalog property.

answered Nov 29, 2010 at 14:18

Bill Berlington

2,4241 gold badge24 silver badges29 bronze badges

Collectives™ on Stack Overflow

C# How To Update Entity Model Connection String

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related