LINQ query examples

Our LINQ query examples contain a collection of sample DevForce LINQ queries organized according to the type of operator being demonstrated. These samples are based on the Microsoft Entity Framework Query Samples, which were in turn based on the MSDN "101 LINQ Samples".

You'll find all these samples, and more, in the Query Explorer utility, which will allow you to download the code and database to explore LINQ at your own pace.

The following pages contain snippets from many of the samples in the Query Explorer to briefly show query topics by operation.

• Restriction operators - Where, Any, All
• Projection operators - Select, SelectMany, anonymous projections
• Ordering and Grouping operators - OrderBy, OrderByDescending, ThenBy, ThenByDescending, GroupBy 
• Aggregate operators - Count, Sum, Min, Max, Average 
• Set operators - First, Distinct, Union, Concat, Interset, Except 
• Paging operators - Take, Skip
• Span operators - Include
• Relationship navigation - Using navigation properties in a query
• Join operators - When to use Join
• Using closures
• Inheritance operators - OfType