How can I write for 2 database connection string to app.config ?

Question

I am using 2 different databases in a project and I do not want to deal with sql codes. How do I configure connection string?

Answer 1

An app.config file can have multiple connection strings. Each must be given a unique name so that your code can specify the the appropriate one for the query. For example:

<configuration>
    <connectionStrings>
        <add name="Database1" connectionString="Data Source=Server1;Initial Catalog=Database1;Integrated Security=SSPI" providerName="System.Data.SqlClient" />
        <add name="Database2" connectionString="Data Source=Server2;Initial Catalog=Database2;Integrated Security=SSPI" providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

Answer 2

You also use ConfigurationManager to access the conectionstrings in the app.config.

https://learn.microsoft.com/en-us/dotnet/api/system.configuration.configurationmanager.connectionstrings?view=dotnet-plat-ext-5.0

You should read the 'note:' about the deployment of the app.config and what you must understand and do for program deployment that uses an app.config.

https://www.codeproject.com/Articles/6538/Configuration-Settings-File-for-providing-applicat