How could you control connection pooling behavior?

Technology CommunityCategory: ADO.NETHow could you control connection pooling behavior?
VietMX Staff asked 3 years ago

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.