You can manage connection pools using certain keywords in your connection string. The important ones include the following:
- ConnectionTimeout — this is used to specify the wait period (in seconds) when a new database connection is requested for. The default value is 15.
- MinPoolSize — this represents the minimum number of connections in the pool.
- MaxPoolSize — this represents the maximum number of connections in the pool. The default value is 100.
- Pooling — this controls if connection pooling is turned on or off and can have a value of true of false. When this is set to true, the requested connection is retrieved from the appropriate connection pool.