Multiple result set from a Stored Proc using LINQ

hi,
I have a admittedly weird stored proc which returns 0 or 1, but also returns an xml using select, which is the result i need.  now when i dragged the stored proc to the DBML the resulting method is returning int(which means it is returning only the return value not the select return result set.), if i change the method to return IMultiple Result , should it return all the result set? do i have to do anything else?

thanks
jyotishbAsked:
Who is Participating?
 
Fernando SotoConnect With a Mentor RetiredCommented:
Hi jyotishb;

Here is a link showing step by step on how to do it.

http://blogs.msdn.com/swiss_dpe_team/archive/2008/02/04/linq-to-sql-returning-multiple-result-sets.aspx

Fernando
0
 
Fernando SotoRetiredCommented:
Have you tried the steps posted in the link?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.