Republished with Permission - Original Article
Over the last few weeks I've 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 model relational databases using .NET classes. You can use
LINQ expressions to query the database with them, as well as
update/insert/delete data.
Below are the first five parts of my LINQ to SQL 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
In these previous LINQ to SQL blog posts I demonstrated how
you could use LINQ query expressions to programmatically retrieve data from a
database.
In today's blog post I'll cover how you can also use
database stored procedures (SPROCs) and user defined functions (UDFs) with your
LINQ to SQL data model. Today's blog post will specifically cover how to
call SPROCs to query and retrieve data from the database. In my next blog
post in this series I'll then show how you can optionally also use SPROCs to update/insert/delete
data from the database.