Build SqlConnectionStringBuilder from connection string : SqlConnectionStringBuilder « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlConnectionStringBuilder

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);

   }
}

Parsed SQL Connection String Parameters:
  Database Source = .\sqlexpress
  Database = Northwind
  Use Integrated Security = True
  Min Pool Size = 5
  Max Pool Size = 5
  Lifetime = 600
  Connection Reset = True