.NET, the SqlConnection object, and multi-threading

The obvious solution is to just re-create the SqlConnection object every time a database call requires one – in this case, it would never be shared. Is there any reason not to do this?

On the contrary, that’s absolutely what you should do. That’s the behaviour SqlConnection was designed for. You should use a Using statement to automatically close the connection at the end of the block you’re using it for, and the connection pool mechanism will automatically handle the real underlying connections to the database.

Leave a Comment