<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <appSettings>
    <environments>
      <environment id="1" name="dev" connectionString="Data Source=mydevserver,1433;Initial Catalog=/your database name/>;User id=myUser;Password=myPassword;" folder="c:\dev\" />
      <environment id="2" name="traning" connectionString="Data Source=mytraningserver,1433;Initial Catalog=/your database name/>;User id=myUser;Password=myPassword;" folder="c:\traning\" />
      <environment id="3" name="prod" connectionString="Data Source=myprodserver,1433;Initial Catalog=/your database name/>;User id=myUser;Password=myPassword;" folder="c:\traning\" />
    </environments> 
  </appSettings>
</configuration>

    <add key="Instance" value="localhost"/>
    <add key="User" value="myuser"/>
    <add key="Password" value="mypassword"/>
    <add key="FilePath" value="c:\temp\"/>

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionStrings>
        <add name="Test" connectionString="Data Source=.;Initial Catalog=OmidPayamak;Integrated Security=True" providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
    <connectionStrings>
        <add name="Test" connectionString="Data Source=.;Initial Catalog=OmidPayamak;Integrated Security=True;folder=c:\dev\" providerName="System.Data.SqlClient" />
    </connectionStrings>
</configuration>

<?xml version="1.0"?>
<configuration>
  <configSections>
    <section name="jobSection"
      type="MyConfiguration.JobSection, MyConfiguration" />
  </configSections>
  <jobSection>
    <jobs>
      <job id="1" name="Job Name A" />
      <job id="2" name="Job Name B" />
    </jobs>
  </jobSection>
</configuration>

INSERT INTO [dbo].[appConfigs] ([id] ,[name] ,[status] ,[connection] ,[dbname] ,[username] ,[password] ,[folder] ,[certificate])
SELECT 1 as [id] ,'dev' as [name] ,1 as [status] ,'MyDBDerver,1433;' as [connection] ,'MyDB;' as [dbname],'Myuser' as [username]           ,'MyPassword' as [password] ,'c:\dev\' [folder] ,*
FROM OPENROWSET(BULK N'C:\myfolder\publickey.cer', SINGLE_BLOB) AS [certificate];

CREATE     PROCEDURE [dbo].[uspGetConnection] (@env sysname = NULL)
AS
BEGIN
    SET NOCOUNT ON;
	SELECT [id],[name],[status],[connection],[dbname],[username],[password],[folder],[certificate] FROM [Dump].[dbo].[appConfigs] where name = @env
    SET NOCOUNT OFF;
END;
GO

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace Update_column_descriptions
{
    class EnvConnection
    {
        public void GetConnectionSettings(String env)
        {
            //Console.WriteLine("Your env: " + env);
            var connectionString = ConfigurationManager.AppSettings["ConnectionString"];
            string getConnectionSQL = "dbo.uspGetConnection";
            SqlConnection con = new SqlConnection(connectionString);
            SqlCommand cmd = new SqlCommand(getConnectionSQL, con);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter param;
            param = cmd.Parameters.Add("@env", SqlDbType.VarChar, 128);
            param.Value = env;

            con.Open();
            var Reader = cmd.ExecuteReader();
            int i = 1;
            string name;
            string status;
            string connection;
            string dbname;
            string username;
            string password;
            string folder;
            string certificate;

            if (Reader.HasRows)
            {
                while (Reader.Read())
                {
                    name = String.Format("{0}", Reader["name"]);
                    status = String.Format("{0}", Reader["status"]);
                    connection = String.Format("{0}", Reader["connection"]);
                    dbname = String.Format("{0}", Reader["dbname"]);
                    username = String.Format("{0}", Reader["username"]);
                    password = String.Format("{0}", Reader["password"]);
                    folder = String.Format("{0}", Reader["folder"]);
                    certificate = String.Format("{0}", Reader["certificate"]);
                    connectionString = "Data Source=" + connection + "Initial Catalog =" + dbname + "User id =" + username + "Password=" + password;
                    Console.WriteLine(name + "," + status + "," + connection + "," + dbname + "," + username + "," + password + "," + folder + "," + certificate);
                    Console.WriteLine(connectionString);
                    SqlConnection conTarget = new SqlConnection(connectionString);

                    i += 1;
                }
            }
            Reader.Close();
            con.Close();
        }
    }
}

            string env;
            Console.Write("Enter the environment (dev, traning): ");
            env = Console.ReadLine();
            Console.WriteLine("You have chosen: " + env);

            var getConnection = new EnvConnection();
            getConnection.GetConnectionSettings(env);

string certificate;
...
certificate = String.Format("{0}", Reader["certificate"]);

{
  "XeroApi": {
    "BaseUrl": "https://api.xero.com",
    "ConsumerKey": "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx",
    "ConsumerSecret": "yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy",
    "SigningCertPath": "{path-to-signing-cert.pfx}",
    "SigningCertPassword": "{leave blank if your signing cert was created without a password}"
  }
}

INSERT INTO [dbo].[appConfigs] ([id] ,[name] ,[status] ,[connection] ,[dbname] ,[username] ,[password] ,[folder] ,[certificate])
SELECT 1 as [id] ,'dev' as [name] ,1 as [status] ,'MyDBDerver,1433;' as [connection] ,'MyDB;' as [dbname],'Myuser' as [username]           ,'MyPassword' as [password] ,'c:\dev\' [folder] ,*
FROM OPENROWSET(BULK N'C:\myfolder\publickey.cer', SINGLE_BLOB) AS [certificate];

[certificate] [varbinary](max) NULL