[Mono-devel-list] Nested SqlDataReader fails?

[Jörg Rosenkranz]

Hello Eduardo,

> -----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."

Joerg.