Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

Obtain a nonpooled connection

using System; using System.Data.SqlClient; class MainClass {     public static void Main()     {                          using (SqlConnection con = new SqlConnection())             {                 // Configure the SqlConnection object's connection string.                 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();             }     } }