SqlConnection.ClearAllPools

Question

What is SqlConnection.ClearAllPools ? and what is pools in c sharp

Krishna Garad · Answer

It's the concept of connection pooling. First when we create the connection with connection string. in our connection string one option is min pool and max pool we have to set this for pooling of our connection. Pooling is the point where the connection is stored. When we open and close the connection but still that connection is stored in pooling. For every time SqlConnection will not create new connection insted it use the connection from that pool only. Pool will store our connection object in it the benifit of it is very fastly we can create the connection with database instead of creating new connection. SqlConnection.ClearAllPools will clear this poll object.

Krishna Garad · Answer

Check the diagram for pooling which will give more brief explanation about pooling. When first time we close the connection the connection is closed but it is stored in pool and on second time when we create connection it is pick from this pool.