Build SqlConnectionStringBuilder from connection string : SqlConnectionStringBuilder : ADO.Net C# Examples

    
using  System;
using  System.Data.SqlClient;

class  MainClass
{
        public  static  void  Main(string[]  args)
        {
                string  conString  =  @"Data  Source=.\sqlexpress;"  +
                        "Database=Northwind;Integrated  Security=SSPI;"  +
                        "Min  Pool  Size=5;Max  Pool  Size=15;Connection  Reset=True;"  +
                        "Connection  Lifetime=600;";

                SqlConnectionStringBuilder  sb1  =  new  SqlConnectionStringBuilder(conString);

                Console.WriteLine("Parsed  SQL  Connection  String  Parameters:");
                Console.WriteLine("    Database  Source  =  "  +  sb1.DataSource);
                Console.WriteLine("    Database  =  "  +  sb1.InitialCatalog);
                Console.WriteLine("    Use  Integrated  Security  =  "  +  sb1.IntegratedSecurity);
                Console.WriteLine("    Min  Pool  Size  =  "  +  sb1.MinPoolSize);
                Console.WriteLine("    Max  Pool  Size  =  "  +  sb1.MinPoolSize);
                Console.WriteLine("    Lifetime  =  "  +  sb1.LoadBalanceTimeout);
                Console.WriteLine("    Connection  Reset  =  "  +  sb1.ConnectionReset);

      }
}