Multiple result sets from store procedure

[Alexandro Velarde]

Hi Igor,
I'm writting a test to retrieve multiple result sets from a Oracle
stored procedure to minimize round trips to the server (ex: Invoice
with invoice details). I haven't seen an example for this in your
site.

I just want to know if it is supported by BLToolKit.

Thanks again,
Alexandro

[Robert Koritnik]

Hi Alexandro

You've asked this question long time ago and have most likely gotten
an answer to it... Nevertheless I would like to tell you that this is
indeed supported. And works rather well. You have to use MapResultSet
array.

To simplify things even further I've written a simple MapResultSet
builder class that makes work with these easier. You can check it out
here:
http://erraticdev.blogspot.com/2011/08/bltoolkit-mapresultset-builder.html

Best regards,
Robert

On Nov 22 2011, 9:56 pm, Alexandro Velarde