LINQ Fundamentals in C#
This course teaches you how to use the LINQ syntax to select, filter, extract, partition, identify, union, join, group, and aggregate data contained in C# collections.
What you'll learn
LINQ can filter and extract data from collections efficiently. In this course, LINQ Fundamentals in C#, you’ll learn to apply LINQ queries to sets of data to extract meaningful information in an efficient manner. First, you’ll explore how to create LINQ queries, where to learn more about LINQ, and how to select and order data from sets of data. Next, you’ll discover how to filter data, get distinct values, and identify the kind of data contained within collections. Finally, you’ll learn how to work with multiple sets of data, group data into sets, and aggregate data to produce statistics for solving business problems. When you’re finished with this course, you’ll have the skills and knowledge of LINQ needed to apply queries in your everyday applications to produce data efficiently.
Table of contents
- The Methods for Selecting a Specific Item 4m
- Search Forward for an Element Using First() 2m
- Search Forward for an Element Using FirstOrDefault() 3m
- Search Backward for an Element Using Last() 2m
- Search Backward for an Element Using LastOrDefault() 2m
- Searching for Only One Element Using Single() 3m
- Searching for Only One Element Using SingleOrDefault() 3m
- When to Use Which Method 4m
- Using the Take() Method to Extract Data 2m
- Using the Range Operator with the Take() Method 3m
- Conditionally Extract Data Using the TakeWhile() Method 1m
- Skip() Past Beginning Elements in a Collection 3m
- Get Distinct() Values from a Collection 2m
- Extract Distinct Objects Using DistinctBy() Method 2m
- Split Large Collections into Smaller Collections Using Chunk() 3m
- Using SequenceEqual() with Integer Collections 4m
- Using SequenceEqual() with Object Collections 2m
- Using SequenceEqual() with Comparer Class 3m
- Using Except() with Integer Collections 3m
- Find Products That Do Not Have Sales Using Except() 2m
- Using Except() with Comparer Class 2m
- Using the ExceptBy() Method 2m
- Find Products That Do Not Have Sales Using ExceptBy() 2m
- Using Intersect() with Integer Collections 1m
- Find Products That Have Sales Using Intersect() 2m
- Using Intersect() with Comparer Class 1m
- Using the IntersectBy() Method 1m
- Find Products That Have Sales Using IntersectBy() 2m
- Using Count() and Filtering the Count 3m
- Using Min() and Max() Methods 2m
- Using MinBy() and MaxBy() Methods 2m
- Using Average() and Sum() Methods 2m
- Simulate Sum() Using Aggregate() 2m
- Using Aggregate() Method with a Custom Expression 1m
- Using Grouping with Aggregation 4m
- Making Aggregation More Efficient 5m
- Classification of LINQ Queries 2m
- Deferred Execution, Streaming, and Non-streaming 4m
- The Classes for Illustrating Deferred Execution 2m
- Illustrating Deferred Execution Using ForEach() 5m
- Step-through Demo of Deferred Execution 2m
- Using IEnumerator and GetEnumerator() 2m
- Show Streaming Nature of Where() and Take() Methods 2m
- Create Custom Filtering Extension Method 3m
- Apply Take() to Custom Filtering Method 1m
- Use Yield Keyword to Create Streaming Extension Method 3m
- Use the Yield Keyword with Take() Method 1m
- Use the Yield Keyword with OrderBy() Method 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.