Instruction

This is a quick tip for how to parse any connection string in C#.

Description

DbConnectionStringBuilder is an inbuilt class from the Microsoft which allow us to parse connection string into KeyValue pair object.

Please find the sample code below.

using System;
using System.Data.Common;

namespace ParseConnectionString
{
    class Program
    {
        static void Main(string[] args)
        {

            string connectionString = "Url=https://webapp.scm.azurewebsites.net/api/triggeredwebjobs/CreateMappings/run;Username=$WebApp;Password=fW1XKyW0oLAcJ2";

            DbConnectionStringBuilder dbConnectionStringBuilder = new DbConnectionStringBuilder();
            dbConnectionStringBuilder.ConnectionString = connectionString;
            string url = (string)dbConnectionStringBuilder["Url"];
            string username = (string)dbConnectionStringBuilder["Username"];
            string password = (string)dbConnectionStringBuilder["Password"];

            Console.WriteLine(string.Format("Username:{0}  Password:{1}  URL:{2}", username, password, url));
            Console.ReadKey();
        }
    }
}

Cheers!!!