ASP.NET & SQL Server connection string

Question

I want to create a global value inside asp net for getting SQL Server connection string.

Should I create a public read only string?

public static readonly string connectionString="myconnection string";

inside a class?

Or do I need to add a key value inside Web.Config?

<connectionStrings>
    <add name="SqlDatabase"
         connectionString="yourConnectionString"
         providerName="System.Data.SqlClient" />
</connectionStrings>

And to use it inside get or post request

public string Get(int id)
{
     var connectionString = WebConfigurationManager.ConnectionStrings["SqlDatabase "].ConnectionString;
     return "connectionString";
}

This string will be used from many client request at same time.

Define the connection string in the web.config. You could create a static class with a static readonly public string property that is initialized in the static constructor of the class and reads in that value from the connection string once from the web.config. — Igor
– Igor, Commented Nov 29, 2018 at 18:44

Yash Soni · Accepted Answer · 2018-11-29 18:52:06Z

1

add your connection string in web config as

<connectionStrings>
  <add name="DbContext" 
       connectionString="Server=localhost; Database=mydbname;
       Integrated Security=True"; providerName="System.Data.SqlClient" />
</connectionStrings>

now read from the application using this code

System.Configuration.ConfigurationManager.
    ConnectionStrings["DbContext"].ConnectionString;

thats how you can use it across applications and can change the connection string from web config after deployment of the application

answered Nov 29, 2018 at 18:52

Yash Soni

7644 silver badges15 bronze badges

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

2 Comments

Kahn Kah Over a year ago

how would you use it to a SQLConnection conn variable?

Yash Soni Over a year ago

read connection string using the second code block above, use that to initialize SQLConnection and enter connection string in param, on the left set it to variable conn, which will hold the connection the the DB

Christopher · Accepted Answer · 2018-11-29 18:52:28Z

1

It goes in your web.config or appsettings.json (for .net core). Read about Dependency Injection to learn more about the new/cool/easy way to handle all this stuff.

answered Nov 29, 2018 at 18:52

Christopher

10.7k14 gold badges79 silver badges99 bronze badges

Comments

Shailly Kudiyal · Accepted Answer · 2018-11-30 06:23:18Z

0

In cs file you can use it as:- SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.AppSettings["connection.connection_string"].ToString());

answered Nov 30, 2018 at 6:23

Shailly Kudiyal

212 bronze badges

1 Comment

Shailly Kudiyal Over a year ago

Collectives™ on Stack Overflow

ASP.NET & SQL Server connection string

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related