Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Obtain a pooled connection

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