Mega Code Archive

 

Categories / C# / ADO Database

 

Connection String

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();         }         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                 "Pooling = False";              //specify nonpooled connection             con.Open();         }     } }