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

On Oct 12, 7:36 am, Jon <JonMYa...@gmail.com> wrote:
> 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

>From the MSDN documentation, it looks like it will be automatically
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.

"Jon" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

> Hello, in the below, would the connection on dbCommand be
> automatically closed once the code has left the using statement

Yes.


--
Mark Rae
ASP.NET MVP
http://www.markrae.net