I had a question about the connection object itself - basically what is the best way 'end' the connection.
If I call connection.Close(); does this leave the connection available in the connection pool or is it closed completely? eg. removed from the pool. Also, if I call .Close(); and .Dispose(); does that also leave it in the pool?
What is the best order to close and or dispose? 1. Reader 2. Command 3. Connection