LINQ, Stored Procedures and Multiple Recordsets
Thursday, May 15th, 2008Update: This post has a follow up here: LINQ, Stored Procedures and Multiple Recordsets: How-To
I wanted to use a LINQ with a stored procedure that would return multiple recordsets, like this:
CREATE PROCEDURE spReturnMultiple
AS
–first set
SELECT value1 FROM table1
–second set
SELECT t1.value1, t2.value2
FROM [...]
Use the Highlighter