“open/close” SqlConnection or keep open?
Stick to option a. The connection pooling is your friend.
Stick to option a. The connection pooling is your friend.
Yes Yes. Either way, when the using block is exited (either by successful completion or by error) it is closed. Although I think it would be better to organize like this because it’s a lot easier to see what is going to happen, even for the new maintenance programmer who will support it later: using … Read more