Will the connection be part of the connection pool or not? This means that the connection will be used throughout the application instead of creating a new one each time it is opened.
Please note that for a connection pool to work, the connection string must be EXACTLY the same, that is, you cannot change the character in the string (even spaces) and work with the pool. Thus, the connection is created:
"SERVER=localhost;DATABASE=myDataBase;USER=###;PASSWORD=***;POOLING=FALSE;"
will not be used in conjunction with the creation of:
" SERVER=localhost;DATABASE=myDataBase;USER=###;PASSWORD=***;POOLING=FALSE;"
because of the leading space.
source share