What is Connection Pooling in ADO.NET?

Technology CommunityCategory: ADO.NETWhat is Connection Pooling in ADO.NET?
VietMX Staff asked 3 years ago

ADO.NET uses a technique called connection pooling, which minimizes the cost of repeatedly opening and closing connections. Connection pooling reuses existing active connections with the same connection string instead of creating new connections when a request is made to the database. It involves the use of a connection manager that is responsible for maintaining a list, or pool, of available connections for a given connection string. Several pools exist if different connection strings ask for connection pooling.