Linq - How to get multipule results from SP call

microsoft.public.dotnet.framework

15 Oct 2007 4:05 PM

GenCode

Prob a dumb question but here goes

I am calling an SP from Linq
The SP returns multiple results

First a select returns a table
then an int return value (int)

When I call my SP like this

DataClassesMyDataContext dc = new DataClassesMyDataContext();
int ret = dc.msp_MySP(MyParm1, MyParm2);

I can only get the int result, obviously in the ret value above.

So question is how do I get the selects result that was returned from
the SP immediately before it?

Thanks Ed,