Closing a database connection

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Hello, in the below, would the connection on dbCommand be
automatically closed once the code has left the using statement or is
it better that I close it?

using (DbCommand dbComm = db.GetStoredProcCommand("Es"))
{
some code
}

thank you,

Jon
 
Hello, in the below, would the connection on dbCommand be
automatically closed once the code has left the using statement or is
it better that I close it?

using (DbCommand dbComm = db.GetStoredProcCommand("Es"))
{
some code

}

thank you,

Jon
Click to expand...
From the MSDN documentation, it looks like it will be automatically
Click to expand...
disposed at the end of the using block. The principle seems to be
this: If the object is an instance of a class that implement the
IDisposable interface, and if it is declared in a using statement,
then it will be automatically disposed when it exits the using block.

In your case, DbCommand does implement the IDisposable interface,
among others, so the answer is yes.
 
Back
Top