Getting the connectionstring in .net 4

Question

I want to get a connection string from the app.config file.

connectionString = System.Configuration.ConfigurationSettings.AppSettings["DBEntities"];

But it doesn't work. It's empty.

I cannot access the System.Configuration.ConfigurationManager because it's .NET 4. How can I get my connection string from the app.config?

can you post your web.config with the connectionstring section — Nealv
– Nealv, Commented Oct 15, 2010 at 10:57

Nalaka526 · Accepted Answer · 2012-10-12 04:46:31Z

79

Use

string connectionString = ConfigurationManager.ConnectionStrings[connectionName].ConnectionString;

Make sure to add reference to System.configuration in your project.

11.5k21 gold badges86 silver badges119 bronze badges

answered Oct 15, 2010 at 11:00

3,9014 gold badges42 silver badges50 bronze badges

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

Comments

Cyril Gandon · Accepted Answer · 2013-04-11 09:32:49Z

8

In .net 4 you have to use:

ConfigurationManager.ConnectionStrings["name of connection string in web.config"]

More about it is here and here.

17.1k15 gold badges84 silver badges124 bronze badges

answered Oct 15, 2010 at 11:00

6,8848 gold badges62 silver badges91 bronze badges

+1 but the question is tagged with c# so instead of () you want []

vc 74 · Accepted Answer · 2010-10-15 10:56:53Z

Add a reference to System.Configuration to your project and use ConnectionStrings instead of AppSettings