Csharp/C Sharp/Database ADO.net/SQL Server Connection Pool

SqlConnection connection pool for SQL server

<source lang="csharp"> using System; using System.Data; using System.Data.SqlClient; class ConnectionPooling {

 public static void Main() {
   SqlConnection mySqlConnection =
     new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;" +
       "max pool size=10;min pool size=5"
     );
   for (int count = 1; count <= 10; count++)
   {
     Console.WriteLine("count = "+ count);
     DateTime start = DateTime.Now;
     mySqlConnection.Open();
     TimeSpan timeTaken = DateTime.Now - start;
     Console.WriteLine("Milliseconds = "+ timeTaken.Milliseconds);
     Console.WriteLine("mySqlConnection.State = "+mySqlConnection.State);
     mySqlConnection.Close();
   }
 }

}

      </source>