[ASP. NET decryption Reading Notes] connection pool

When using SQL Connection pooling, you can place additional options in a connection string to modify how Connection Pooling works. for example, you can specify the minimum and maximum size of the connection pool or even completely disable Connection pooling.

Here's a list of the Connection Pooling options that you can add to the SQL server connection string:

Connection lifetime-destroys a connection after a certain number of seconds. The default value is 0, which indicates that connections shoshould never be destroyed.

Connection Reset-Indicates whether connections shoshould be reset when they are returned to the pool. The default value is true.

Enlist-Indicates whether a connection shocould be automatically enlisted in the current transaction context. The default value is true.

Max pool size-the maximum number of connections allowed in a single connection pool. The default value is 100.

Min pool size-the minimum number of connections allowed in a single connection pool. The default value is 0.

Pooling-determines whether Connection pooling is enabled or disabled. The default value is true.