.NET Essentials: Working with LINQ

Course details

Want a simpler, more consistent way to query data ? Language-Integrated Query (LINQ) may be what you're looking for. This general-purpose query toolset allows allows developers to filter, sort, aggregate, and query data directly within C# code. In this course, join Walt Ritscher as he helps you get up and running with LINQ, focusing on LINQ to Objects. Walt begins by showing how to use LINQPad, the code editor and code runner you can use to write and test the LINQ examples provided in this course. He then highlights the key .NET features that power LINQ, the essential elements of a query, and the different types of query expressions. Plus, learn about filters, aggregates, groups, element operations, quantifying data, and partition tools. Along the way, Walt provides challenges that help you grasp how to apply these concepts in the real world.

Concepts

0. Introduction

01 - Welcome
02 - What you should know
03 - How to access the sample code on GitHub

1. The Spirit of LINQ

04 - Why build a query engine in a programming language
05 - Explore LINQ essential parts

2. Work with LINQPad

06 - Why use LINQPad
07 - Initial tour of LINQPad
08 - Set destination folder for course examples
09 - Explore the expression editor
10 - Explore the statements editor
11 - Show formatted output with the Dump method
12 - Explore the program editor
13 - Run a subset of code

3. Key Parts of .NET

14 - Implicit variable typing
15 - Anonymous types
16 - Object initializers
17 - Collection initializers
18 - Inline code with lambda expressions
19 - Extension methods
20 - More extension methods
21 - Generic types

4. The Parts of a Query

22 - What sources are queryable
23 - The Enumerable class
24 - Learn how to use the Enumerable static methods
25 - Learn how to use the Enumerable extension methods
26 - Learn how to use the Query Expression syntax
27 - What sources revisited
28 - Deferred execution - When does the query run
29 - Combine methods with execution pipelines
30 - Combine extension methods and query expressions

5. Generate

31 - The Empty and DefaultIfEmpty methods
32 - The Repeat method
33 - The Range method

6. Basics

34 - The three types of query expressions
35 - Review query expression clauses
36 - Examples of three query expressions
37 - The select clause
38 - Learn how to use select to project into another type
39 - Select into anonymous type
40 - Learn how to use expressions with select
41 - Challenge - Write select expressions
42 - Solution - Write select expressions
43 - Index into another sequence

7. Filtering

44 - The Where method
45 - Learn how to use logical operators with the Where method
46 - Explore the OfType class definitions
47 - The OfType method
48 - Challenge - Filter results with Where
49 - Solution - Filter results with Where

8. Aggregation

50 - Sum, Average, and other aggregates
51 - Create custom aggregates

9. Groups and Other Stuff

52 - The GroupBy method
53 - GroupBy query expression
54 - GroupBy with ElementSelector
55 - GroupBy with ResultSelector
56 - Iterate over groups
57 - Combine two sequences
58 - Flatten sequence with SelectMany
59 - Challenge - Group results by color values
60 - Solution - Group results by color values

10. Element Operations

61 - First and Last methods
62 - The FirstOrDefault method
63 - The ElementAt method
64 - Single and SingleOrDefault methods

11. Set Operations

65 - The Distinct method
66 - The Intersect method
67 - The Union method
68 - The Except method
69 - Find duplicate values

12. Quantify Data

70 - Learn how to use the Any method to detect empty sequence
71 - Learn how to use Any method to determine if element exists
72 - The Contains method
73 - The All method

13. Partition

74 - Skip and Take methods
75 - Conditional Skip and Take methods

14. Other

76 - Learn how to use LINQ in a .NET application
77 - Learn how to use MoreLinq for extended query syntax
78 - Additional MoreLinq examples

Continue Your Journey

79 - Next steps