Dear sir,<BR>I am implementing a Data Access Layer using c# in a web application <BR>and I have a function that return an IDataReader to the business layer<BR>How I can close the IDataReader after returning it?<BR>can I close it in the caller method in the business layer?<BR>the code:<BR>public IDataReader GetPlans()<BR><BR>{<BR><BR>connAdmin.Open();<BR><B R>SqlCommand cmd = new SqlCommand();<BR><BR>cmd.Connection = connAdmin;<BR><BR>cmd.CommandText = "SELECT * FROM Admin_vPlans";<BR><BR>IDataReader dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection) ;<BR><BR>return dataReader;<BR><BR>}<BR><BR>=============<BR> Thanks