SQL Server connection string in code vs config file in ASP.NET site

Question

I already have a connection string in my config file

<connectionStrings>
    <add
        name="ConnectionString"
        connectionString="Data Source=*;Initial Catalog=*;User ID=*;Password=*"
        providerName=".NET Framework Data Provider for SQL Server" />

Currently I am just adding another connection string in my .cs file:

SqlConnection myConnection =
    new SqlConnection("user id=*;password=*;server=localhost;");

I want to use config file string to connect to a database in the .cs file without adding another string. How can I do that?

using (SqlConnection cn =
    new SqlConnection(
        ConfigurationManager.ConnectionStrings["MyDbConn"].ToString()))

This was the code I found, is there any shorter way?

No, no shorter way unless you wrap the retrieval of the connection string in a read-only property in a separate static class or something, giving you MyConnectionStrings.ConnectionString; or however you decide to name it. — Cᴏʀʏ
– Cᴏʀʏ, Commented Nov 18, 2011 at 3:05

Tu Tran · Accepted Answer · 2011-11-18 03:03:20Z

4

Using ConnectionStrings property of System.Web.Configuration.WebConfigurationManager to get connection string in config file

answered Nov 18, 2011 at 3:03

Tu Tran

1,9971 gold badge29 silver badges51 bronze badges

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

3 Comments

Tu Tran Over a year ago

@Bhrugesh Patel: If you have only one connection string, then use WebConfigurationManager.ConnectionStrings[0].ConnectionString

Bhrugesh Patel Over a year ago

I have actually two.. One is to localhost, another is to actual MS SQL server.. But I will remove localhost once I am done testing

Tu Tran Over a year ago

Then just use name instead of index which you've found in accepted anwser :-)

Chris Fulstow · Accepted Answer · 2011-11-18 03:07:52Z

2

Not really, but you could wrap it in its own little helper function:

private static string GetConnectionString(string name)
{
    return WebConfigurationManager.ConnectionStrings[name].ConnectionString;
}

using (var cn = new SqlConnection(GetConnectionString("MyDbConn"))) { ... }

answered Nov 18, 2011 at 3:07

Chris Fulstow

42k10 gold badges91 silver badges114 bronze badges

1 Comment

Bhrugesh Patel Over a year ago

Thanks :) Connection up and running

Paige Cook · Accepted Answer · 2011-11-18 03:15:59Z

2

Just use System.Configuration.ConfigurationManager.ConnectionStrings to get access to the connection string defined in your config file.

 var myconnectionString = System.Configuration.ConfigurationManager
      .ConnectionStrings["ConnectionString"].ConnectionString;

edited Nov 18, 2011 at 3:15

answered Nov 18, 2011 at 3:08

Paige Cook

22.6k3 gold badges60 silver badges68 bronze badges

Comments

Martin Zikmund · Accepted Answer · 2011-11-18 03:23:01Z

0

You can create a static helper class, named Config or something similar and give it a property ConnectionString, that will return the long "WebConfigurationManager.ConnectionStrings["MyDbConn"].ConnectionString" thing. That is the approach I usually go with in my projects and it's actually very easy to use.

public static class Config
{
   public static string ConnectionString
   {
      get
      {
         return WebConfigurationManager.ConnectionStrings["MyDbConn"].ConnectionString;
      }
   }
}

This approach is the most useful when more classes need to acccess the connection string and this way you have a centralized access to it and easy to change solution.

edited Nov 18, 2011 at 3:23

answered Nov 18, 2011 at 3:07

Martin Zikmund

39.2k7 gold badges74 silver badges95 bronze badges

Collectives™ on Stack Overflow

SQL Server connection string in code vs config file in ASP.NET site

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related