LINQ to SQL and multiple result sets in Stored Procedures

Discount Airline Tickets » LINQ to SQL and multiple result sets in Stored Procedures

Wed, 07 May 2008 01:15:16 GMT

PingBack from http://www.travel-hilarity.com/travel-airline-tickets/?p=1147

re: LINQ to SQL and multiple result sets in Stored Procedures

Him — Wed, 07 May 2008 01:48:38 GMT

Jason, what if we want to return multiple resultsets that are not typed? like anonymous types?

like for example:

select pr.Title, pr.Description from products

select o.orderid, u.userid from orders o

inner join users u on o.userid = u.userid

re: LINQ to SQL and multiple result sets in Stored Procedures

Leakybagel — Tue, 21 Jul 2009 18:02:59 GMT

If you get errors like 'Procedure expects parameter <@Name>, which was not supplied:

Take a look at the stored procedure code created in the Designer.cs file, and copy the parameter list and attributes that match them to the SP params: [Parameter(Name="CustomerID", DbType="Int")]

When passing multiple parameters to ExecuteMethodCall, you don't need to create an object array, just list each parameter.

Can you skip over one of the results, or is each result set returned in order?

re: LINQ to SQL and multiple result sets in Stored Procedures

Milind Kansagara — Sat, 14 Nov 2009 07:46:11 GMT

Hi!!

I have understand you requierment but here I am having a query that in in combination of another table and returns 2 tables one is having same structure of one of the table of database and other is having just only one field now i want to convert in to dataset how can i do this please help me ?

I am having following error when converting and the 2nd table have the field which is not acctually in the table so how can it be done ?

[Error]

The required column 'UserId' does not exist in the results.

[/Error]

Regards,

Milnd Kansagara