return connection pool with/whthout using block

[waertf]

If the connection pool is enable,what the situation if the connection object out of using block? return to pool or auto dispose(if dispose, is meaning disconnect server actually?)
1. with using block

Code: Select all

void connect()
{
using (var pgSqlConnection = new PgSqlConnection(pgCSB.ConnectionString))
{
pgSqlConnection.Open();
pgSqlConnection.Close();
}
}

2.without using block

Code: Select all

void connect()
{
var pgSqlConnection = new PgSqlConnection(pgCSB.ConnectionString);
pgSqlConnection.Open();
pgSqlConnection.Close();
}

[Pinturiccio]

The Dispose() method calls the Close() method internally; therefore, you don't need to call Close() if you use a using block.

When calling Close() or Dispose(), the PgSqlConnection object and its internal resources are freed for garbage collection, but the internal object with the physical connection to the server is placed to the pool when 'Pooling=true'.