Republished with Permission - Original Article
In Part 1 of my LINQ to SQL blog post series I discussed
"What is LINQ to SQL" and provided a basic overview of some of
the data scenarios it enables.
In my first post I provided code samples that
demonstrated how to perform common data scenarios using LINQ to SQL including:
How to query a database
How to update rows in a database
How to insert and relate multiple rows in a database
How to delete rows in a database
How to call a stored procedure
How to retrieve data with server-side paging
I performed all of these data scenarios using a LINQ to SQL
class model that looked like the one below:
In this second blog post in the series I'm going to go into
more detail on how to create the above LINQ to SQL data model.
LINQ to SQL, the LINQ to SQL Designer, and all of the
features that I'm covering in this blog post series will ship as part of the
.NET 3.5 and Visual Studio "Orcas" release.
You can follow all of the steps below by downloading either Visual Studio "Orcas" Beta 1 or Visual Web Developer Express "Orcas" Beta1.
Both can be installed and used side-by-side with VS 2005.