is it possible

[João Santa Bárbara]

hi all
is it possible to use 2 datareaders at the same time with the same
connection ????
how ???
if not ? how can i do a clone from a connection ????

thks
JSB

 

[Philipp Schumann]

Hi JSB,

cloning is certainly not an option. In the upcoming .NET Framework 2.0,
there will almost certainly be support for "multiple active result sets"
(MARS) - until then, you're constrained to one active data reader per
connection. Thus, your only option is to use two concurrent connections
(which isn't bad when connection pooling is used, which it is by default at
least for the MSSQL ADO.NET provider).