Hi Alvin,

Are you using DataReader? In this case you must call Close Method after
and depends that CommandBehavior you choose, CloseConnection is default
if you don't pass nothing in the ExecuteReader method from the command object.

Only after Close the DataReader the connection is closed.

Furthermore, by default connection pool is enabled and uses the
same string connection to create the pool. For desabling use "pooling=false;".

see "max pool size" also.