C# Language-Integrated Query (LINQ)

This course teaches you how to use the LINQ syntax to select, filter, extract, partition, identify, union, join, group, and aggregate data contained within collections.
Course info
Rating
(62)
Level
Intermediate
Updated
Mar 17, 2021
Duration
2h 32m
Table of contents
Course Overview
Why You Should Use LINQ
Using LINQ Select and Order Operations
Extract Data Using Filtering and Element Operations
Extract Distinct Values, Assign Values and Partition Collections
Identify What Kind of Data Is Contained in Collections
Compare and Union Two Collections
Joining Two Collections Together
Creating Groups of Data Using GroupBy
Aggregating Data in Collections
Understanding Deferred Execution in LINQ
Description
Course info
Rating
(62)
Level
Intermediate
Updated
Mar 17, 2021
Duration
2h 32m
Your 10-day individual free trial includes:

Expert-led courses

Keep up with the pace of change with thousands of expert-led, in-depth courses.
Description

LINQ can filter and extract data from collections much more efficiently and with less code. In this course, C# Language-Integrated Query (LINQ), you’ll learn over 60 LINQ queries using C#. First, you’ll explore why you should use LINQ, how to select, order, filter and extract data using LINQ queries. Next, you’ll discover how to use LINQ queries to work with multiple collections, group and aggregate data. Finally, you’ll learn what goes on under the hood with LINQ queries by understanding deferred execution. When you’re finished with this course, you’ll have the skills and knowledge of LINQ needed to query data efficiently and with less code from any collection of data.

About the author
About the author

Paul loves teaching and technology, and has been teaching tech and business topics for over 30 years. Paul helps clients develop applications, and instructs them on the best use of technology.

More from the author
More courses by Paul D. Sheriff
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hello, my name is Paul Sheriff and welcome to my course, C# Language‑Integrated Query (LINQ). I'm a business IT consultant at PDS Consulting with over 34 years of experience creating enterprise applications. Stop writing loops to iterate over collections and start using LINQ instead. LINQ can filter and extract data from collections much more efficiently and with less code than you can write. This course covers all the major LINQ operations with over 60 demos using the query and method syntaxes. Some of the major topics you will learn in this course are why use LINQ, using LINQ to select in order collections, filter and find data in collections, extract distinct values, assign values and partition collections, compare and union two collections together, create groups of data, aggregate data using SUM, MIN, MAX, and AVERAGE, understand deferred execution and how it maximizes efficiency. By the end of this course, you will have the required skills to use LINQ in your own applications and to go on to learn more advanced topics in LINQ, with some of the other great courses in the Pluralsight library. Before beginning this course, you should be familiar with C# and Visual Studio. I hope you'll join me on your mission to becoming a great programmer by employing LINQ in my course, C# Language‑Integrated Query at pluralsight.com.