Connection Pooling (ADO.NET)

Switch View :

ScriptFree

.NET Framework 4

Connecting to a data source can be time consuming. To minimize the cost of opening connections, ADO.NET uses an optimization technique called connection pooling, which minimizes the cost of repeatedly opening and closing connections. Connection pooling is handled differently for the .NET Framework data providers.

In This Section

SQL Server Connection Pooling (ADO.NET): Provides an overview of connection pooling and describes how connection pooling works in SQL Server.
OLE DB, ODBC, and Oracle Connection Pooling (ADO.NET): Describes connection pooling for the .NET Framework Data Provider for OLE DB, the .NET Framework Data Provider for ODBC, and the .NET Framework Data Provider for Oracle.

Other Resources

Retrieving and Modifying Data in ADO.NET

ADO.NET Managed Providers and DataSet Developer Center