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 [...]
ScottGu – Da LINQ Man!
Thursday, May 15th, 2008For my own reference, the various parts of ScottGu’s LINQ series:
Part 1: Introduction to LINQ to SQL
Part 2: Defining our Data Model Classes
Part 3: Querying our Database
Part 4: Updating our Database
Part 5: Binding UI using the ASP:LinqDataSource Control
Part 6: Retrieving Data Using Stored Procedures
Part 7: Updating our Database using Stored Procedures
Part 8: Executing Custom SQL [...]
LINQ here, LINQ there, LINQ everywhere
Tuesday, April 22nd, 2008According to DA GURU (that’s Scott Guthrie), on his article LINQ to SQL (Part 5 – Binding UI using the ASP:LinqDataSource Control)
We will also take advantage of the built-in paging/sorting support within LINQ to SQL to ensure that features like the product listing paging/sorting are performed not in the middle-tier, but rather in the [...]
Use the Highlighter