Multiple Active Result Sets - general question

[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?

 

[Guest]

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

MARS serves a different function than hierarchical recordsets.

Can one still use hierarchical recordsets (using the SHAPE command) in
ADO.NET?

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!
***************************

 

[Sahil Malik [MVP C#]]

First of all, MARS is a different concept than what you mention (just so
there is no confusion)

Secondly - ditto on whatever Gregory said.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

 

[Griff]

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.

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?