What is the best place to store a connection string?

  • Thread starter Thread starter Leo Muller
  • Start date Start date
L

Leo Muller

I am about to deploy my first ASP.NET project.
But, I was used to store my variables, such as connection strings, in the
global.asa file, in an application. However, these variables are different
on my development and production server. If I use the global.asax file, then
it is in the code behing, compiled part. Thus I can't change the setting on
my production server.

So where is the right place to save my connecting string?

Leo
 
The Web.config file might be a good place. In the system.configuration
namespace, you can find the appropriate methods to access this file in you
application.

Regards,
Kristof
 
That's what I have done - here's part of my Web.config file:
<configuration>
<appSettings>
<add key="MyConnectionString" value="...the connection string goes
here..." />
</appSettings>

I then retrieve it using
ConfigurationSettings.AppSettings["MyConnectionString"]

I also set the BuildAction property of the Web.config file to None, to stop
it overwriting the version on the live server.

Hope that helps!
 
Hi,

This helped me out, it works fine.

thanks,

Leo

Sheila Jones said:
That's what I have done - here's part of my Web.config file:
<configuration>
<appSettings>
<add key="MyConnectionString" value="...the connection string goes
here..." />
</appSettings>

I then retrieve it using
ConfigurationSettings.AppSettings["MyConnectionString"]

I also set the BuildAction property of the Web.config file to None, to stop
it overwriting the version on the live server.

Hope that helps!


Kristof Van Praet said:
The Web.config file might be a good place. In the system.configuration
namespace, you can find the appropriate methods to access this file in you
application.

Regards,
Kristof

file,
then setting
on
Click to expand...
Click to expand...
 
Leo, use the web.config as follows:

<configuration>
<!-- application specific settings -->
<appSettings>
<add key="connectionString" value="user id=your
username;password=userpassword;initial catalog=nameofdatabase;data
source=servername;Connect Timeout=30" />
</appSettings>
<system.web>
 
Back
Top