[Mono-devel-list] Nested SqlDataReader fails?
joergr at voelcker.com
Wed Dec 17 04:36:43 EST 2003
> -----Original Message-----
> From: mono-devel-list-admin at lists.ximian.com
> [mailto:mono-devel-list-admin at lists.ximian.com] On Behalf Of
> Eduardo A. Flores Verduzco
> It seems that when you nest SqlDataReader Read() methods on different
> DataReader objects (even on different methods), the first one
> is lost and an
> exception is thrown or the execution stops with no message.
This is no Mono specific problem. You should get an exception when nesting
SqlDataReader Reads on MS.NET too.
The Microsoft documentation says:
"While the SqlDataReader is in use, the associated SqlConnection is busy
serving the SqlDataReader, and no other operations can be performed on
the SqlConnection other than closing it. This is the case until the Close
method of the SqlDataReader is called. For example, you cannot retrieve
output parameters until after you call Close."
More information about the Mono-devel-list