Min pool size=0

[pavankompella]

Hello experts,

I have an application where I give Min Pool Size=0 and the connection pooling is set to true.

I want to ask you whether my application uses connection pooling even though Min Pool Size is set to zero.

Thanks in advance.

[PRR]

As soon as you make a connection to DB, (rather open a connection) a pool is created for that particular connection string..If u again open a connection from same application and the string is EXACTLY same( even blank spaces make a difference) then the same pool will be used, as the connection string is a match.

"If MinPoolSize is either not specified in the connection string or is specified as zero, the connections in the pool will be closed after a period of inactivity. However, if the specified MinPoolSize is greater than zero, the connection pool is not destroyed until the AppDomain is unloaded and the process ends.

The pool is automatically cleared when a fatal error occurs, such as a failover. "
MSDN

[pavankompella]

Thanks for the info its' really useful to update my knowledge on connection pooling.