C# 9 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.
What you'll learn
LINQ can filter and extract data from collections much more efficiently and with less code. In this course, C# 9 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.
Table of contents
- The Project, Classes, and Data Used in this Course 4m
- Select All Items Using a Simple Loop 3m
- Select All Items Using LINQ 4m
- Select a Single Column 2m
- Select Specific Columns of Data 2m
- Build an Anonymous Class 3m
- Ordering Data 2m
- Ordering Data in Descending Order 1m
- Ordering Data Using Multiple Fields 3m
- Filter Data Using a Where Expression 2m
- Using a Where Expression with Two Fields 1m
- Using a Custom Extension Method for Filtering 2m
- Select a Single Item Using First() and FirstOrDefault() 3m
- Select a Single Item Using Last() and LastOrDefault() 2m
- Select a Single Item Using Single() and SingleOrDefault() 3m
- Understanding the Types of LINQ Execution 2m
- Deferred vs. Immediate and Streaming vs. Non-streaming 3m
- Deferred Execution and GetEnumerator() 6m
- Create Your Own Filtering Extension Method 5m
- Streaming vs Non-Streaming Demonstration 2m
- Create Your Own Streaming Extension Method 3m
- Using 'yield' with Take() and OrderBy() 2m
About the author
Paul has over thirty years of experience architecting information systems and his expertise is in much demand from Fortune 500 companies. Paul is a Pluralsight author, has published 400+ articles, and authored over 14 books on topics ranging from JavaScript, Angular, C#, SQL Server and many .NET technologies. Paul is a frequent speaker at conferences and user groups.