Obtain a pooled connection : SqlConnection « ADO.Net « C# / CSharp Tutorial






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

        }


    }
}








32.13.SqlConnection
32.13.1.Connect to SQLserver
32.13.2.Deal with connection exception
32.13.3.Show the connection properties for SqlConnection
32.13.4.Properties of SqlConnection
32.13.5.SqlConnection connection state
32.13.6.Obtain a pooled connection
32.13.7.Obtain a nonpooled connection
32.13.8.Connection event: state changed and information
32.13.9.Setting Connection Pooling Options
32.13.10.Set AttachDbFilename in connection string
32.13.11.Opens and verifies a connection
32.13.12.Connect to SqlServer Named Instance
32.13.13.Connect to SqlServer and set the IP Address
32.13.14.Connect to SqlServer with Integrated security
32.13.15.Connect to SqlServer with password and id
32.13.16.Connection Display
32.13.17.Get Sql Statistics