To get the database connection string by reading the configuration file App. Config

There are two ways://To get the connection string by reading the configuration file

The first way:

Format of app. Config file:

<?xml version= "1.0" encoding= "Utf-8"?>
<configuration>
<connectionStrings>
<add name= "Sqlconnstr" connectionstring= "Data source= server name; Initial catalog= database name; Integrated security=true"/>
</connectionStrings>
</configuration>

Read the string in the configuration file in SqlHelper by code: (Add Reference: Using System.Configuration;)

private static readonly String constr = configurationmanager.connectionstrings["Sqlconnstr"]. ConnectionString;

The second way:

Format of app. Config file:

<?xml version= "1.0" encoding= "Utf-8"?>
<configuration>
<appSettings>
<add key= "Mysqlconnstr" value= "server=127.0.0.1; User Id=root; Password=root;database=myquery; Charset=utf8; "/>
</appSettings>
</configuration>

To read a string from a configuration file in SqlHelper by code:

private static readonly string Constr =configurationsettings.appsettings["Mysqlconnstr"]. ToString ();

To get the database connection string by reading the configuration file App. Config