SQL server connectivity using ConfigurationManager.ConnectionString

Question

I am not able to use

String connectionString = ConfigurationManager.ConnectionStrings["DevBackup"].ConnectionString;

I am getting error 'The name 'ConfigurationManager' does not exist in the current context'
I have used namespaces

using System.Data.SqlClient;
using System.Data.Sql;

what should be done..?? Am I missing something..??

marc_s · Accepted Answer · 2010-06-05 15:09:47Z

5

You need to add a reference to the System.Configuration assembly to your project, and then a using System.Configuration; statement to your app.

answered Jun 5, 2010 at 15:09

marc_s

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

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

Comments

LittleBobbyTables - Au Revoir · Accepted Answer · 2010-06-05 15:10:51Z

1

Do you also have System.Configuration in your namespaces?

answered Jun 5, 2010 at 15:10

33k25 gold badges113 silver badges115 bronze badges

PhilPursglove · Accepted Answer · 2010-06-18 09:12:53Z

1

For ASP.NET, System.Web.Configuration is the correct namespace to use:

using System.Web.Configuration;
String connectionString = WebConfigurationManager.ConnectionStrings["DevBackup"].ConnectionString;

answered Jun 5, 2010 at 22:58

PhilPursglove

12.6k5 gold badges48 silver badges71 bronze badges