While trying to work through various problems in LINQ that I could easily solve in T-SQL, I found a sample at code.msdn.microsoft.com (I hadn’t seen that sight before, but seems like a potential gold mine).  It is called 101 LINQ Samples and at the time of this writing is the 3rd most popular download on the site.  Looking forward to digging into it.  Here’s the link to the main page with downloads.

Here are the individual links/list of topics:

Restriction Operators

• Where – Simple 1
• Where – Simple 2
• Where – Simple 3
• Where – Drilldown
• Where – Indexed

Projection Operators

• Select – Simple 1
• Select – Simple 2
• Select – Transformation
• Select – Anonymous Types 1
• Select – Anonymous Types 2
• Select – Anonymous Types 3
• Select – Indexed
• Select – Filtered
• SelectMany – Compound from 1
• SelectMany – Compound from 2
• SelectMany – Compound from 3
• SelectMany – from Assignment
• SelectMany – Multiple from
• SelectMany – Indexed

Partitioning Operators

• Take – Simple
• Take – Nested
• Skip – Simple
• Skip – Nested
• TakeWhile – Simple
• TakeWhile – Indexed
• SkipWhile – Simple
• SkipWhile – Indexed

Ordering Operators

• OrderBy – Simple 1
• OrderBy – Simple 2
• OrderBy – Simple 3
• OrderBy – Comparer
• OrderByDescending – Simple 1
• OrderByDescending – Simple 2
• OrderByDescending – Comparer
• ThenBy – Simple
• ThenBy – Comparer
• ThenByDescending – Simple
• ThenByDescending – Comparer
• Reverse

Grouping Operators

• GroupBy – Simple 1
• GroupBy – Simple 2
• GroupBy – Simple 3
• GroupBy – Nested
• GroupBy – Comparer
• GroupBy – Comparer, Mapped

Set Operators

• Distinct – 1
• Distinct – 2
• Union – 1
• Union – 2
• Intersect – 1
• Intersect – 2
• Except – 1
• Except – 2

Conversion Operators

• ToArray
• ToList
• ToDictionary
• OfType

Element Operators

• First – Simple
• First – Condition
• FirstOrDefault – Simple
• FirstOrDefault – Condition
• ElementAt

Generation Operators

• Range
• Repeat

Quantifiers

• Any – Simple
• Any – Grouped
• All – Simple
• All – Grouped

Aggregate Operators

• Count – Simple
• Count – Conditional
• Count – Nested
• Count – Grouped
• Sum – Simple
• Sum – Projection
• Sum – Grouped
• Min – Simple
• Min – Projection
• Min – Grouped
• Min – Elements
• Max – Simple
• Max – Projection
• Max – Grouped
• Max – Elements
• Average – Simple
• Average – Projection
• Average – Grouped
• Aggregate – Simple
• Aggregate – Seed

Miscellaneous Operators

• Concat – 1
• Concat – 2
• EqualAll – 1
• EqualAll – 2

Custom Sequence Operators

• Combine

Query Execution

• Deferred Execution
• Immediate Execution
• Query Reuse

Join Operators

• Cross Join
• Group Join
• Cross Join with Group Join
• Left Outer Join