C# 3 added one of the most revolutionary features of any programming language, and that's none other than LINQ. LINQ has been a flagship feature of C#. Data querying is a fundamental feature of any programming language, but not every language gives developers the tools to do it in an elegant way that reads naturally and is extremely powerful. Even though most developers will get introduced to LINQ early in their C# journey, only a few know how to use it effectively and get the most out of it with the least amount of code. With heavy Microsoft investment, LINQ is improving in every .NET version with better performance and adding new features. In this course, Hannes Lowette will teach you everything there is to know about LINQ and equip you with the knowledge to tackle and querying tasks, whether big or small.
Curriculum
Section 1: Module 1
02 - Welcome 00:36
03 - What will you learn in this course? 00:35
04 - Who is the course for and prerequisites 00:33
05 - Why do we have LINQ? 05:37
06 - A language for querying data 02:03
07 - A first LINQ example 05:22
08 - Why would you want to use LINQ? 03:35
09 - Section recap 00:39
10 - Introduction to our demo solution 03:06
11 - Using a simple where clause 04:30
12 - Refactoring statements into functions 03:46
13 - Chaining multiple where clauses 03:19
14 - Ordering data 04:01
15 - Multi-level ordering 03:25
16 - Using a custom comparer to order 02:57
17 - Section recap 00:55
18 - What is deferred execution in LINQ? 09:34
19 - Retrieving all results 09:49
20 - Retrieving a single item 10:41
21 - Projecting the data to another shape 11:23
22 - Section recap 00:44
23 - Introduction to getting partial results 02:58
24 - Splitting results into chunks 06:22
25 - Using Skip, Take and TakeWhile to retrieve a specific result 07:31
26 - Dividing results into logical parts with GroupBy 07:31
27 - Section recap 00:56
28 - Introduction 02:01
29 - Removing duplicates 03:11
30 - Checking for a single item 03:10
31 - Verifying all items 04:11
32 - Using aggregate functions 09:52
33 - Checking if 2 sequences are equal 02:52
34 - Section recap 00:40
35 - Introduction 01:27
36 - Concatenate two results 01:51
37 - Set operations on queries with the same type 10:03
38 - Exploding a subquery with SelectMany 07:01
39 - Join operations between 2 results 25:26
40 - Section recap 00:43
41 - Introduction 01:03
42 - IQueryable vs IEnumerable 04:39
43 - What can we write LINQ against? 03:49
44 - Making some IEnumerable methods ourselves 09:08
45 - IQueryable behind the scenes 10:48
46 - Section recap 01:14
47 - Why would we want to parallelize our queries? 02:27
