A language for querying data

What will you learn in this course

A first LINQ example

Welcome

Who is the course for and prerequisites

Why do we have LINQ

Why would you want to use LINQ

Introduction to our demo solution

Using a simple where clause

Section recap

Refactoring statements into functions

Ordering data

Section recap

Multi-level ordering

Using a custom comparer to order

What is deferred execution in LINQ

Section recap

Projecting the data to another shape

Retrieving all results

Introduction to getting partial results

Retrieving a single item

Splitting results into chunks

Section recap

Removing duplicates

Introduction

Dividing results into logical parts with GroupBy

Using Skip, Take and TakeWhile to retrieve a specific result

Section recap

Checking for a single item

Introduction

Checking if 2 sequences are equal

Verifying all items

Using aggregate functions

Concatenate two results

Section recap

Introduction

Set operations on queries with the same type

Exploding a subquery with SelectMany

IQueryable vs IEnumerable

What can we write LINQ against

Join operations between 2 results

Section recap

Making some IEnumerable methods ourselves

IQueryable behind the scenes

Things to consider when using PLINQ

Why would we want to parallelize our queries

Potential pitfalls

Introduction to PLINQ

Section recap

Conclusion