# 6 - Joins, Grouping, Aggregating w/ Linq2Sql

5/30/2008

Tags: Linq2Sql LinqPad

Comments: (2)

Author:
Derik Whittaker

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:

Inner Joins
Outter Joins
Groupings (with some Aggregations)
Select top N rows

Click here to Watch this Episode

Download (11.11 MB) (12:07) (1440x900)
Download (7.48 MB) (12:07) (960x600)

Links/Resources:

Linqpad.net

Images/Screen Shots:

Inner Join in Action
Shows a Linq2Sql Inner Join

Outter Join in Action
Shows a Linq2Sql outter join in action

Grouping in Action
Shows a Linq2Sql grouping in Action

Select top 5 In Action
Shows a Linq2Sql Select top 5 in action

Comments: (2)

marc said....

Linq is pretty sweet. Took me a moment to grok the outer join syntax, but you made it clear. Also, great videos--you've got a knack for this. I forwarded your site around to the other developers I work with. Keep the dimecasts coming!

5/30/2008 10:44:57 PM

Yazilim said....

Informative cast

4/17/2009 2:33:21 PM