The documentation included with the version I have installed, version
2, states under the category Retrieving Multiple Rows Using a
SqlDataReader: (emphasis mine)
This section describes a
typical situation where you use the SqlHelper ExecuteReader method
to obtain a SqlDataReader object. There are
various overloaded versions of the ExecuteReader method, which can be
subdivided into three categories:
? Those that accept a
connection string.
? Those that accept a
SqlConnection object. With these methods, the client is in control of
connection lifetime.
? Those that accept a
SqlTransaction object. These methods allow several commands to be
executed within the context of a single transaction.
...
If you
are working with DataReaders, you should control the connection. I
believe I've seen parameters in some method that specify to close the
connection when done, but I'm not sure...
Good luck,
Sam