Solved

Multiple result set from a Stored Proc using LINQ

Posted on 2008-10-23
4
654 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 62

Accepted Solution

by:
Fernando Soto earned 500 total points
Comment Utility
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 62

Expert Comment

by:Fernando Soto
Comment Utility
Have you tried the steps posted in the link?
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

771 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now