ASP.NET Interview Questions & Answers

What is Connection Pool ?

 Connection pool is the collection of connections which are shared between the clients requesting one, once the connection is closed it returns back to the pool and connection to be reused.

What is connection pooling and how do you make your application use it?

Opening database connection is a time consuming operation.
Connection pooling increases the performance of the applications by reusing the active database connections instead of creating new connection for every request.
Connection pooling behavior is controlled by the connection string parameters.
Following are the 4 parameters that control most of the connection pooling behavior:

1. Connect Timeout
2. Max Pool Size
3. Min Pool Size
4. Pooling