Where to store and how to access a connection string

Question

Where to add the connection string in a C# project? Like this string?

<connectionStrings>
    <add name="strConn" 
         connectionString="Data Source=abc;Password=pass;User ID=user" 
         providerName="Oracle.DataAccess.Client">
    </add>
</connectionStrings>

And how can I call it from my program.cs file?

What kind of project: ASP.NET? Winforms? WPF? SIlverlight? COnsole app?? — marc_s
– marc_s, Commented Nov 21, 2011 at 15:23
@marc_s - Its a console app. And i dont see any app.config file in my project? — Gurnor
– Gurnor, Commented Nov 21, 2011 at 15:27
I just selected the XML and hit the 'code' button. What XML was missing then? — RvdK
– RvdK, Commented Nov 21, 2011 at 15:40

user596075 · Accepted Answer · 2011-11-21 15:24:43Z

4

This will be added in the configuration file. If it is an ASP.NET application, then this would be the web.config file. If it is a Winforms/Console application this would be the app.config file.

To call it from the application, you'd have to use the System.Configuration namespace like so:

using System.Configuration;

string YourConnectionString = 
    ConfigurationManager.ConnectionStrings["yourConnStringName"].ConnectionString;

Where "yourConnStringName" is the name of your connectionString in your config file.

answered Nov 21, 2011 at 15:24

user596075

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

2 Comments

Gurnor Over a year ago

I have console app. But i dont see any app.config file in the project? Do i need to add it?

user596075 Over a year ago

Yes, you need to add that. Add items and you'll see configuration file.

Mahmoud Gamal · Accepted Answer · 2011-11-21 15:33:06Z

2

The connection string like the one you posted is placed in a configuration file called app.config and whenever you want to get a connectionstring you can get it like:

string strConn = ConfigurationManager.ConnectionStrings["strConn"].ConnectionString;

see this

edited Nov 21, 2011 at 15:33

answered Nov 21, 2011 at 15:26

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

1 Comment

user596075 Over a year ago

The connection string COULD be stored in appSettings, but the OP seems to want to use the connectionStrings section.

David Aleu · Accepted Answer · 2011-11-21 15:29:42Z

0

Add it to your app.config under <configuration> and to call it from your program.cs use:

ConfigurationSettings.AppSettings["strConn"]

answered Nov 21, 2011 at 15:29

David Aleu

3,9423 gold badges30 silver badges50 bronze badges

Collectives™ on Stack Overflow

Where to store and how to access a connection string

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related