Obtain a pooled connection : SqlConnection : ADO.Net C# Examples

    
using  System;
using  System.Data.SqlClient;

class  MainClass
{
        public  static  void  Main()
        {
                using  (SqlConnection  con  =  new  SqlConnection())
                {
                        con.ConnectionString  =
                                @"Data  Source  =  .\sqlexpress;"  +//  local  SQL  Server  instance
                                "Database  =  Northwind;"  +              //  the  sample  Northwind  DB
                                "Integrated  Security  =  SSPI;"  +  //  integrated  Windows  security
                                "Min  Pool  Size  =  5;"  +                    //  configure  minimum  pool  size
                                "Max  Pool  Size  =  15;"  +                  //  configure  maximum  pool  size
                                "Connection  Reset  =  True;"  +        //  reset  connections  each  use
                                "Connection  Lifetime  =  600";        //  set  max  connection  lifetime

                        con.Open();

                }


        }
}