Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Multiple result set from a Stored Proc using LINQ

Posted on 2008-10-23
4
Medium Priority
?
677 Views
Last Modified: 2013-11-11
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
0
Comment
Question by:jyotishb
  • 2
4 Comments
 
LVL 64

Accepted Solution

by:
Fernando Soto earned 2000 total points
ID: 22787438
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
 
LVL 64

Expert Comment

by:Fernando Soto
ID: 22868146
Have you tried the steps posted in the link?
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
Hello there! As a developer I have modified and refactored the unit tests which was written by fellow developers in the past. On the course, I have gone through various misconceptions and technical challenges when it comes to implementation. I would…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question