# 6 - Joins, Grouping, Aggregating w/ Linq2Sql


5/30/2008
Level: Intermediate
Tags: Linq2Sql LinqPad
Comments: (11)
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:
  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)

Links/Resources:


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: (11)

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

Casino umsonst said....

In my view Spring.Net is very simple and the best one for DI which is used in Linq.Very important and useful. More difficult is to implement it. Not everyone is savvy.It is really greata rticle and nery informative.


2/12/2010 10:29:43 PM


replica rolex said....

He might not go this week, but he's further proof sea dweller that being sea dweller adorable can get you into the semifinals but rolex submariner not much rolex submariner further. Urban is the weakest male link, so he might as well blast submariner off with a submariner submariner blaze of glory with something rolex yachtmaster ridiculous like rolex yachtmaster And I Am Telling You I'm Not yachtmaster Going.


3/12/2010 5:10:29 PM

rolex -submariner said....

With yachtmaster rolex yacht master Jermaine Sellers rolex yacht master gone, dancer Hall remains as the loose cannon in the yacht master bunch. His yacht master confidence hasn't yet meshed with a breakout performance, and replica watches though his replica watches sedate take on Tina Turner's What's Love Got to Do With replica watch It was replica watch interesting, Hall has been the fake watches judges' punching fake watches bag to date.


3/12/2010 5:12:12 PM

rolex yacht master said....

Unless he kills it, say with a seductive Usher throw-down, Hall could be rolex the next to rolex go. Speaking of cute, James is still trying to shake off the whole rolex watch cougar-bait rolex watch thing, but his limp rendition of the too-frequent Idol cover I Don't Want to Be didn't rolex watches exactly show rolex watches off his rock chops. Regardless, assuming he doesn't completely tank, Casey replica rolex will likely make the top 12. He should, however, soar by proving replica rolex his grit this week with something edgier. How about an unplugged rolex replica Kid Rock tune? He's the rolex replica token rocker, which is a good place to be this year, because he's got virtually no competition.


3/12/2010 5:13:51 PM

armani watches said....

Dewyze is on a hot streak, and he's got Simon tissot on his tissot side, so he should play it safe this armani watch week to ensure armani watch a top 12 berth. He's done well playing his acoustic armani watches guitar, so armani watches maybe a Kings of Leon song would work for him. What armani happened armani to you, man? Garcia seemed a shoo-in for audemars piguet watch the top audemars piguet watch three.


3/12/2010 6:37:26 PM

lv watches said....


But he's gotten steadily diminishing returns thanks audemars piguet watches to sleepy audemars piguet watches song choices, like James Morrison's You Give Me Something, which audemars piguet find him audemars piguet fading into the pack. He needs another Straight Up, pronto! Now's lv watch the best lv watch time to wow the judges again with a clever arrangement lv watches of a classic lv watches — perhaps a folky version of Jane's Addiction's Been lv Caught lv Stealing?


3/12/2010 6:42:57 PM

parmigiani watches said....

He's not blowing anyone away, but movado watch slow-and-steady movado watch Lynche is getting it done every week. He's likeable, solid and very comfortable onstage. Big movado watches Mike is almost movado watches certainly going to advance, so a bit more of what the movado judges already movado like, perhaps a touch of Maxwell on parmigiani watch acoustic guitar, could parmigiani watch ensure his spot. Either Lambert is pulling a rope-a-dope and is planning to emerge parmigiani watches as a camera-ready parmigiani watches superstar from his mullet-duckling persona, or we're reading too much into his phoenix-like rise from the ashes of two twitchy weeks ago


3/12/2010 6:48:02 PM

parmigiani watches said....

He's not blowing anyone away, but movado watch slow-and-steady movado watch Lynche is getting it done every week. He's likeable, solid and very comfortable onstage. Big movado watches Mike is almost movado watches certainly going to advance, so a bit more of what the movado judges already movado like, perhaps a touch of Maxwell on parmigiani watch acoustic guitar, could parmigiani watch ensure his spot. Either Lambert is pulling a rope-a-dope and is planning to emerge parmigiani watches as a camera-ready parmigiani watches superstar from his mullet-duckling persona, or we're reading too much into his phoenix-like rise from the ashes of two twitchy weeks ago


3/12/2010 6:48:15 PM

cheap sexy corsets said....

Hot sale [b][ur]=http://www.yo2underwear.com]cheap sexy corsets[/url][/b],[b][ur]=http://www.yo2underwear.com/asian-style-tapestry-purple-corset-p-13.html] are loved by many ladies.


3/14/2010 12:07:30 AM


Name: *
Email (not displayed): *
Url:
Comments: *



So, you Human...?