Getting Started With Linq In C#

Start working productively with LINQ in less than 2 hours

What you'll learn

Understand the key differences between LINQ and loops

Use the most common LINQ methods to work with collections

Identify and fix common mistakes when using LINQ with collections

Use LINQ to refactor away from conditionals

Learn new LINQ methods and overloads from recent .NET versions

Requirements

Know the C# syntax to declare and initialize objects

Write conditionals (such as if, else, and switch) and loops (such as for, while, and foreach)

Work with collections like arrays and lists

Have the latest version of the .NET SDK installed

Description

Collections are everywhere. Comments in a post, purchased items in an invoice, and guests in a hotel reservation.We often work with these collections using for, foreach, and other loops. But C#, has a feature specifically designed for working with collections:Language Integrated Query (LINQ).With LINQ, you filter, transform, and query collections, using more concise and readable code than traditional loops.This is the one C# feature you can't ignore. In fact, it's the best of all C# features. Ever.What you will learn?In this course, we're covering everything you need to know to start working productively with LINQ, in less than 2 hours.After taking this course, you will:Understand the key differences between LINQ and loops.Learn the most frequently used LINQ methods for working with collections.Identify and fix common mistakes when using LINQ.Refactor away from conditionals using LINQ.Explore the latest LINQ methods and overloads from recent .NET versions.LINQ works with XML files and database records too. But, in this course, we're focusing on LINQ and collections like arrays and lists.Think of this course like the 20% of the LINQ features you're using 80% of the time (That's the Pareto Principle, by the way). We're not covering every single LINQ method out there, but the most frequently used ones. And that's on purpose. In our every day coding (and jobs) we keep using a handful of methods most of the time.Who is this course for?If you're a beginner or intermediate C# developer who want to write more compact and expressive code when working with collections, this course is for you.You should be comfortable declaring and initializing C# objects and working with conditionals, loops, and collections such as arrays and lists.By the end of this course, you'll be ready to productively manipulate collections with LINQ.See you in the first lesson.

Overview

Section 1: Introduction

Lecture 1 Getting Started

Lecture 2 What's LINQ?

Section 2: LINQ vs. Loops

Lecture 3 Filter Collections Using Where

Lecture 4 Understand the IEnumerable Type

Lecture 5 Use LINQ with Older Versions

Lecture 6 Write Extensions Methods

Lecture 7 Write Delegates Using Func and Action

Lecture 8 Write Lambda Expressions

Lecture 9 Exercise: Find Your Favorite Movies

Lecture 10 LINQ and Declarative Programming

Lecture 11 LINQ and Immutability

Lecture 12 LINQ and Laziness

Lecture 13 Wrap-up!

Section 3: Most Common LINQ Methods

Lecture 14 Transform a Collection With Select

Lecture 15 Transform a Collection Using the Position of Elements

Lecture 16 Query Collections with Any and All

Lecture 17 Group Elements of a Collection

Lecture 18 Group Elements and Transform Every Group

Lecture 19 Group Elements by More Than One Property

Lecture 20 Use Anonymous Objects With GroupBy

Lecture 21 Order Elements of a Collection

Lecture 22 Choose One Element with First and FirstOrDefault

Lecture 23 Choose One Element with Last and LastOrDefault

Lecture 24 Choose One Element with Single and SingleOrDefault

Lecture 25 Choose and Leave Out Elements with Take and Skip

Lecture 26 Exercise: Write a Paginate Method

Lecture 27 Exercise: Refactor From Loops to LINQ

Lecture 28 Query Collections of Numbers With Sum, Min, and Max

Lecture 29 Flatten a Collection of Collections With SelectMany

Lecture 30 Find Unique Elements With Distinct

Lecture 31 Perform Set Operations With Intersect, Union, and Except

Lecture 32 Exercise: Use LINQ Methods

Lecture 33 Carry An Operation With Aggregate

Lecture 34 Use LINQ Query Syntax

Lecture 35 Wrap-up!

Section 4: Common LINQ Mistakes

Lecture 36 Use the Right LINQ Methods

Lecture 37 Write Null Checks with FirstOrDefault

Lecture 38 Avoid Multiple Evaluations of a LINQ Query

Lecture 39 Exercise: Remove Mistakes

Lecture 40 Wrap-up!

Section 5: Refactoring With LINQ

Lecture 41 Replace Comparisons with Any

Lecture 42 Replace a Set of Choices with FirstOrDefault

Lecture 43 Validate Objects With All

Lecture 44 Exercise: Add a Recommended Movie

Lecture 45 Wrap-up!

Section 6: New LINQ Features

Lecture 46 Split a Collection Into Buckets With Chunk

Lecture 47 Find Unique Elements With DistinctBy

Lecture 48 Use Take Method with Ranges

Lecture 49 Use FirstOrDefault with a Safe Default

Lecture 50 Count Elements of a Collection With CountBy

Lecture 51 Select Elements And Their Position With Index

Lecture 52 Wrap-up!

Section 7: Conclusion

Lecture 53 Wrap-up!

C# developers who want to write more compact and expressive code when working with collections,C# developers looking to stay up-to-date with LINQ features in recent .NET versions