– This means that during application execution many identical connections will be repeated opened and closed.
– To minimize the cost of opening connections ADO.NET uses an optimization technique called Connection Pooling.
– It manages connections by keeping alive a set of active connections for each given connection configuration.
– When the user or application call the close() (i.e con.close()), the connection is not going to close rather it returns back to the connection pool and ready to be used in the next open call.
– So Finally, Connection pools are container that contain open and reusable connections.
– By default, Connection pooling is enabled in ADO.NET. If you want to turn it off or disable it then specify Pooling = False in the connectionstring being used.