Linq2Sql Episodes

# 32 Harnessing the Power of Linq2Sqls Delayed Execution

8/4/2008

Level: Intermediate

Author: Derik Whittaker

Tags: Linq2Sql

Views: (361) Watched: (1830)

In this episode we will how to use Linq2Sqls Delayed Execution process to modify or append query syntax to our statements.

This can be used to remove duplication withen your query logic.

# 23 Adding a New Feature to DimeCasts.Net - Data Access

7/15/2008

Level: Beginner

Author: Derik Whittaker

Tags: Linq2Sql New Feature

Views: (348) Watched: (1847)

In this episode we will start a new series where we are going to be walking through the coding process of adding a new feature to the Dimecasts.net website. In this episode we will create the needed data access to allow us to pull the data correctly.

# 17 Performing Subselects with Linq2Sql

7/1/2008

Level: Intermediate

Author: Derik Whittaker

Tags: Linq2Sql LinqPad

Views: (362) Watched: (2530)

In this episode we will walk you though the the various ways to perform subselects with Linq2Sql.

We will also take a look at the SQL that is generated. We will be doing all of our coding in this episode in LinqPad

# 7 (re)Creating your DB with Linq's DataContext for testing

6/3/2008

Level: Intermediate

Author: Derik Whittaker

Tags: Linq2Sql

Views: (293) Watched: (2230)

In this episode we will learn how to use the DataContext object that is part of Linq2Sql to build/rebuild our data base for testing.

We will walk though the creation of the database, the creation of data and learn how to wire this process up to our Tests.

# 6 Joins, Grouping, Aggregating w/ Linq2Sql

5/30/2008

Level: Intermediate

Author: Derik Whittaker

Tags: Linq2Sql LinqPad

Views: (1095) Watched: (2861)

In this episode we take a look at how to create various types of Linq2Sql statements.  All the statements created in this episode are done using the really sweat LinqPad tool.

The types of statements that are reviewed here are:

  1. Inner Joins
  2. Outter Joins
  3. Groupings (with some Aggregations)
  4. Select top N rows

# 5 Introduction to Linq2Sql

5/29/2008

Level: Beginner

Author: Derik Whittaker

Tags: Linq2Sql

Views: (336) Watched: (2569)

In this episode we do an introductory of Linq2Sql.  This is meant to be a beginners guide.

The items that are covered are:

  1. Learn how to create the data connection via Server Explorer
  2. How to use the Linq2Sql Designer
  3. Review the DataContext object that is generated
  4. Simple Linq2Sql Statements