DataReader and DB connection closing?

  • Thread starter Thread starter rockdale.green
  • Start date Start date
R

rockdale.green

I am using Microsoft.Practices.Enterprise.Library

When I use IDataReader I saw this line
"It is the responsibility of the caller to close the connection and
reader when finished."

I was wondering if I close the DataReader do I automatic ally close the
Connection? If not , how can I close the Connection outside the
ExecuteReader function?

I code snippet is like following:

------------------------------------------------
IDataReader oDr =null;

Database db = DatabaseFactory.CreateDatabase();

string sqlCommand = "my_stored_proc";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);


oDr = db.ExecuteReader(dbCommand);


/*DO SOMETHING WITH oDR*/


/*I close the DataReader here, do I need to close connection also?*/
oDr.Close();
 
Hi,

You can specify CommandBehaviour.CloseConnection in ExecuteReader
(connection will be closed on oDr.Close()) or you have to manually close
associated connection.
And make sure you use try/finally or using construct to enforce disposing of
reader.
 
Use [using] statement to close the DataReader. When the using statement's
block completes, the DataReader is closed, closing the connection with it.

// Using "using" will cause both the DataReader and connection to be
// closed. (ExecuteReader will close the connection when the
// DataReader is closed.)
using (IDataReader dataReader = db.ExecuteReader(cmd))
{
while (dataReader.Read())
{
...
}
}
 
Back
Top