Closing a database connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon - 12 Oct 2007 12:36 GMT

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

Reply to this Message

gnewsgroup - 12 Oct 2007 14:49 GMT

> Hello, in the below, would the connection on dbCommand be
> automatically closed once the code has left the using statement or is
[quoted text clipped - 9 lines]
>
> 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.

Reply to this Message

Mark Rae [MVP] - 12 Oct 2007 17:11 GMT

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

Yes.

Signature

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

Reply to this Message

Closing a database connection

Free Magazines