jyotishb
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Have you tried the steps posted in the link?