Connection Pooling

using System;
using System.Data;
using System.Data.SqlClient;

namespace ConnectionPooling
{
 class MainClass
 {
   public static void Main()
   {
     SqlConnection cnt = new SqlConnection(
       "server=someServer; database=Northwind; uid=sa; pwd=sa; " +
       "min pool size=5; max pool size=10");

     // open the SqlConnection object 10 times
     for (int count = 1; count <= 10; count++)
     {
       Console.Write("Connection count = " + count + ", ");

       DateTime startTime = DateTime.Now;
      
       cnt.Open();
       TimeSpan timeTaken = DateTime.Now - startTime;

       Console.Write("Milliseconds = " + timeTaken.Milliseconds + ", ");
       Console.WriteLine("cnt.State = " + cnt.State);

       cnt.Close();      
     }
    
     Console.ReadLine();
    }
 }
}

Main Points

1. Connection pooling offers a greate performane improvement.
2. When you close a connection, that connection isn't actually closed but  marked  as unused and stored in the pool, ready to be used again.
3. Default pooling size is from 0 to 100.

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/782823/viewspace-366414/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/782823/viewspace-366414/