Linq and stored procs with multiple result sets

Question

User1085970526 posted

I tried to use linq to sql to get data from my stored procedures, but it only returns the first recordset. Is there any way to change this? Even better, how about creating relationships in the objects generated by the results?

Answer 1

User303162096 posted

Great refernce for this stuff:  http://weblogs.asp.net/scottgu/archive/2006/06/18/DLINQ-with-Stored-Procedures.aspx

Answer 2

User1085970526 posted

That article doesn't seem to be about multiple recordsets

Say I had a sproc like this:

create proc usp_getOrder @orderNo int

select * from ordertable where orderno= @orderNo

select * from address where orderNo = @orderNo

select * from litem where orderNo = @orderNo

This will hit the DB once and return three recordsets.

I'd love for it to return a nice, hierarchical tree of objects so I could do something like this:

lblState.Text = myOrder.Address.State;

Of course, I'm lazy so I want the framework to do as much of this as possible for me because I don't want to write lots of code that I'll need to maintain later.