Linq2Sql Episodes


# 32
8/4/2008
Level: Intermediate
Tags: Linq2Sql
Comments: (0)
Views: (10004)
Watched: (1589)
Downloads: (3387)
Author:
Derik Whittaker
 
Presented By:
DataDynamics.Com


Harnessing the Power of Linq2Sqls Delayed Execution
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.
Click here to Watch this Episode

Download (22.54 MB) (7:29) (1440x900)
Download (13.43 MB) (7:29) (960x600)
# 23
7/15/2008
Level: Beginner
Tags: Linq2Sql New Feature
Comments: (0)
Views: (5072)
Watched: (1604)
Downloads: (3558)
Author:
Derik Whittaker


Adding a New Feature to DimeCasts.Net - Data Access
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.
Click here to Watch this Episode

Download (21.72 MB) (9:54) (1440x900)
Download (13.94 MB) (9:54) (960x600)
# 17
7/1/2008
Level: Intermediate
Tags: Linq2Sql LinqPad
Comments: (0)
Views: (5843)
Watched: (2200)
Downloads: (5127)
Author:
Derik Whittaker


Performing Subselects with Linq2Sql
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
Click here to Watch this Episode

Download (8.16 MB) (6:51) (1440x900)
Download (5.16 MB) (6:51) (960x600)
# 7
6/3/2008
Level: Intermediate
Tags: Linq2Sql
Comments: (0)
Views: (7511)
Watched: (1983)
Downloads: (4083)
Author:
Derik Whittaker


(re)Creating your DB with Linq's DataContext for testing
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.
Click here to Watch this Episode

Download (13.28 MB) (10:58) (1440x900)
Download (9.62 MB) (10:58) (960x600)
# 6
5/30/2008
Level: Intermediate
Tags: Linq2Sql LinqPad
Comments: (0)
Views: (18063)
Watched: (2480)
Downloads: (5701)
Author:
Derik Whittaker


Joins, Grouping, Aggregating w/ Linq2Sql
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
Click here to Watch this Episode

Download (11.11 MB) (12:07) (1440x900)
Download (7.48 MB) (12:07) (960x600)
# 5
5/29/2008
Level: Beginner
Tags: Linq2Sql
Comments: (0)
Views: (5920)
Watched: (2287)
Downloads: (4514)
Author:
Derik Whittaker


Introduction to Linq2Sql
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
Click here to Watch this Episode

Download (16.37 MB) (10:40) (1440x900)
Download (11.30 MB) (10:40) (960x600)