ConnectionReset

   
 


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("  Connection Reset = " + sb1.ConnectionReset);

        SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString);

        sb2.ConnectionReset = true;

        Console.WriteLine("  " + sb2.ConnectionString);

    }
}

    


LoadBalanceTimeout

   
 
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("  Lifetime = " + sb1.LoadBalanceTimeout);

        SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString);

        sb2.LoadBalanceTimeout = 600;

        Console.WriteLine("  " + sb2.ConnectionString);

    }
}

    


MaxPoolSize

   
 
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("  Max Pool Size = " + sb1.MaxPoolSize);

        SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString);

        sb2.MaxPoolSize = 15;

        Console.WriteLine("  " + sb2.ConnectionString);

    }
}

    


MinPoolSize

   
 
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("  Min Pool Size = " + sb1.MinPoolSize);

        SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString);

        sb2.MinPoolSize = 5;

        Console.WriteLine("  " + sb2.ConnectionString);

    }
}

    


IntegratedSecurity

   
 
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("  Use Integrated Security = " + sb1.IntegratedSecurity);

        SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString);

        sb2.IntegratedSecurity = true;

        Console.WriteLine("  " + sb2.ConnectionString);

    }
}

    


InitialCatalog

   
 
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("  Database = " + sb1.InitialCatalog);

        SqlConnectionStringBuilder sb2 = new SqlConnectionStringBuilder(conString);

        sb2.InitialCatalog = "Northwind";

        Console.WriteLine("  " + sb2.ConnectionString);

    }
}

    


new SqlConnectionStringBuilder(conString)

   
 

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("  " + sb1.ConnectionString);

    }
}