Dive into an advanced C# tutorial focusing on LINQ (Language Integrated Query), a powerful feature that enables querying, projecting, and filtering data from various sources. Explore LINQ's capabilities in manipulating data from databases, XML documents, and .NET objects through hands-on coding exercises. Begin with an introduction to LINQ, create a .NET Core Console Application, and progress through essential concepts like extension methods and lambda expressions. Compare LINQ query syntax with TSQL syntax, and delve into LINQ queries, understanding the differences between method and query syntax, as well as deferred and immediate execution. Master LINQ operators, including join, grouping, and element operators, while also covering aggregate, generation, set, partitioning, and conversion operators. Gain practical experience with provided code examples and access a comprehensive video playlist for in-depth learning. By the end of this 3-4 hour tutorial, acquire advanced C# skills and harness the full potential of LINQ in your development projects.
Overview
Syllabus
⌨️ Part 1 - Introduction
⌨️ Create a .NET Core Console Application - Understand how LINQ Works
⌨️ Understanding Extension Methods
⌨️ Undering Lambda Expressions
⌨️ Compare LINQ Query Syntax with TSQL Syntax
⌨️ Part 2 - LINQ Queries
⌨️ Create .NET Console Application
⌨️ Method Syntax vs Query Syntax
⌨️ Understanding Deferred Execution vs Immediate Execution
⌨️ Using the Join Operator to Perform Inner Join Queries
⌨️ Perform Left Outer Join Query using LINQ - GroupJoin Operator
⌨️ Part 3 - LINQ Operators
⌨️ GroupBy and ToLookup LINQ Operators
⌨️ The All, Any and Contains Qualifier Operators
⌨️ The Element Operators FirstOrDefault, Single, SingleOrDefault etc..
⌨️ Part 4 - More LINQ Operators
⌨️ The Aggregate Operators Aggregate, Average, Count, Sum, Max
⌨️ The Generation Operators DefaultIfEmpty, Empty, Range, Repeat
⌨️ The Set Operators Distinct, Except, Intersect, Union
⌨️ The Partitioning Operators Skip, SkipWhile, Take, TakeWhile
⌨️ The Conversion Operators ToList, ToDictionary, ToArray
⌨️ The Let and Into Keywords
⌨️ The Projection Operators Select, SelectMany
⌨️ Course Summary
Taught by
freeCodeCamp.org
