" Live as if you were to die tomorrow. Learn as if you were to live forever.. "
 - Mahatma Gandhi

  1. Home
  2. .Net Development Tips
  3. How to close a Connection object automatically when we close the associated Reader object

How to close a Connection object automatically when we close the associated Reader object

In some situations we feel the need to close a SQL connection object immediately after the SQL query operation with a associated reader is complete. We can not close the connection before we complete all the operations related to the reader. Also we need to close the connection immediately after we finish the use of reader object.


In .NET we have a mechanism to achieve this objective using an overloaded form of ExecuteReader() function with an extra argument as shown below:
OleDbDataReader oReader = oCommand.ExecuteReader(CommandBehavior.CloseConnection);

The argument “CommandBehavior.CloseConnection” will specify that the connection object will close automatically when we close the Reader object.The sample code is given below:

 

OleDbConnection connectionObj = new OleDbConnection(connectionString);
OleDbCommand commandObj = new OleDbCommand();
OleDbDataReader readerObj = null;
commandObj = new OleDbCommand(sqlQuery, connectionObj);
connectionObj.Open();
readerObj = commandObj.ExecuteReader(CommandBehavior.CloseConnection);

 

Now when we close the Reader object then the Connection object will close automatically.

 

Amit Mohapatra , Dot Net Developer, Mindfire Solutions.
Related Tags: ADO.NET, Database, NET
Author : Amit Mohapatra

Leave a Reply