Article: LINQ to SQL (Part 6 - Retrieving Data Using Stored Procedures)

Denis Gobo — Mon, 20 Aug 2007 15:02:00 GMT

LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data.

This is the 6th article that Scott Guthrie has written about LINQ. The first 5 can be found below.

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

What is covered in the 6th article?

To SPROC or not to SPROC? That is the question....
The Steps to Map and Call a SPROC using LINQ to SQL
How to Map a SPROC to a LINQ to SQL DataContext
How to Call our Newly Mapped SPROC
Mapping the Return Type of SPROC Methods to Data Model Classes
Handling SPROC Output Parameters
Handling Multiple Result Shapes from SPROCs
Supporting User Defined Functions (UDFs)
Summary

Read the 6th article here: http://weblogs.asp.net/scottgu/archive/2007/08/16/linq-to-sql-part-6-retrieving-data-using-stored-procedures.aspx

Good LINQ to SQL Posts

Denis Gobo — Thu, 12 Jul 2007 13:03:00 GMT

Over the last few weeks Scott Guthrie has been writing a series of blog posts that cover LINQ to SQL. LINQ to SQL is a built-in O/RM (object relational mapper) that ships in the .NET Framework 3.5 release, and which enables you to easily model relational databases using .NET classes. You can use LINQ expressions to query the database with them, as well as update/insert/delete data. It is a very good read so do check it out.

LINQ to SQL Part 1: Introduction to LINQ to SQL
LINQ to SQL Part 2: Defining our Data Model Classes
LINQ to SQL Part 3: Querying our Database
LINQ to SQL Part 4: Updating our Database

Denis Gobo : ORM

Article: LINQ to SQL (Part 6 - Retrieving Data Using Stored Procedures)

Good LINQ to SQL Posts