Correct handling of Connection.Dispose() and Close()

  • Thread starter Thread starter _DG
  • Start date Start date
D

_DG

There seems to be some disagreement on the subject of disposing vs
closing connections, and exactly when to do that. I have an app that
repeatedly refers to the same database. Each access involves only a
few lines of code, but I understand that it is still good to at least
*close* the connection after each access.

Q1: Given the short duration of each access and the fact that the
same db is being constantly reopened, does it make sense to just close
rather than dispose? (Does dispose impair pooling operation?)

Q2: What is the preferred method for enclosing access statements to
ensure that close (or dispose) is called? A short sample in C# would
be helpful.
 
Q1: Given the short duration of each access and the fact that the
same db is being constantly reopened, does it make sense to just close
rather than dispose? (Does dispose impair pooling operation?)
Click to expand...

Close is allright, dispose does not impair pooling operation, but it does
clear stateful information out of the connection variable.
Q2: What is the preferred method for enclosing access statements to
ensure that close (or dispose) is called? A short sample in C# would
be helpful.
Click to expand...

Either a using block, or a try catch finally ~ with dispose in the finally.
 
Back
Top