is it possible

  • Thread starter Thread starter João Santa Bárbara
  • Start date Start date
J

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
 
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).
 
Back
Top