Multiple Active Result Sets - general question

  • Thread starter Thread starter Griff
  • Start date Start date
G

Griff

Having worked through an example (I'm novice status), it seems that this is
less efficient than using hierarchical recordsets in normal ADO.

Can one still use hierarchical recordsets (using the SHAPE command) in
ADO.NET?
 
Griff said:
Having worked through an example (I'm novice status), it seems that this is
less efficient than using hierarchical recordsets in normal ADO.
Click to expand...

MARS serves a different function than hierarchical recordsets.
Can one still use hierarchical recordsets (using the SHAPE command) in
ADO.NET?
Click to expand...

Yes and no. You cannot use it in ADO.NET, but you can still use the ADO
library in .NET. The downside is you end up with the Interop overhead, so it
is not an ideal solution if you can solve your problem in .NET alone.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Yes and no. You cannot use it in ADO.NET, but you can still use the ADO
library in .NET. The downside is you end up with the Interop overhead, so
it
is not an ideal solution if you can solve your problem in .NET alone.
Click to expand...

Hmmm

I've found hierarchical recordsets in Classic ADO to be such a powerful tool
that I'm really surprised that it's now possible to do this using ADO.NET.

Was I the only person using hierarchical recordsets?
 
Back
Top