Connection Pooling

Question

User1904516115 posted

Connection Pooling is a feature of SQL Server or ADO.NET?

Answer 1

User1120430333 posted

Connection Pooling is a feature of SQL Server or ADO.NET?

It's part of ADO.NET, which involves pooling a connection when the user credentials are the same for a given connection with all connections using the same credentials are pooled to use one connection. It doesn't matter if the database is MS SQL Server, Oracle, Sybase, etc. and etc.

Answer 2

User-271186128 posted

Hi vinodkpasi,

Connection Pooling is a feature of SQL Server or ADO.NET?

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.

More details, please check the Connection Pooling.

SQL Server Connection Pooling (ADO.NET)

OLE DB, ODBC, and Oracle Connection Pooling

Best regards,
Dillion