Advanced C# – LINQ Tutorial

Learn about LINQ in this advanced C# course. LINQ provides a set of operators that enable developers to query, project, and filter data in arrays, collections, and other data sources. It can be used to query and manipulate data from databases, XML documents, and .NET objects. ✏️ Course from @GavinLon 💻 Code Part 1: https://github.com/GavinLonDigital/ThePretendCompanyApplication 💻 Code Part 2: https://github.com/GavinLonDigital/LINQExamples_1 💻 Code Part 3: https://github.com/GavinLonDigital/LINQExamples_2 💻 Code Part 4: https://github.com/GavinLonDigital/LINQExamples_3 🔗 Full Advanced Course Playlist Link: https://www.youtube.com/watch?v=3cfVmcAkR2w&list=PL4LFuHwItvKaOi-bN1E2WUVyZbuRhVokL ⭐️ Contents ⭐️ ⌨️ (0:00:00) Part 1 - Introduction ⌨️ (0:07:37) Create a .NET Core Console Application - Understand how LINQ Works ⌨️ (0:14:40) Understanding Extension Methods ⌨️ (0:22:43) Undering Lambda Expressions ⌨️ (0:31:44) Compare LINQ Query Syntax with TSQL Syntax ⌨️ (0:38:33) Part 2 - LINQ Queries ⌨️ (0:42:07) Create .NET Console Application ⌨️ (0:51:10) Method Syntax vs Query Syntax ⌨️ (0:54:25) Understanding Deferred Execution vs Immediate Execution ⌨️ (1:01:33) Using the Join Operator to Perform Inner Join Queries ⌨️ (1:08:59) Perform Left Outer Join Query using LINQ - GroupJoin Operator ⌨️ (1:18:12) Part 3 - LINQ Operators ⌨️ (1:34:39) GroupBy and ToLookup LINQ Operators ⌨️ (1:39:02) The All, Any and Contains Qualifier Operators ⌨️ (1:55:30) The Element Operators (FirstOrDefault, Single, SingleOrDefault etc..) ⌨️ (2:05:01) Part 4 - More LINQ Operators ⌨️ (2:21:51) The Aggregate Operators (Aggregate, Average, Count, Sum, Max) ⌨️ (2:28:36) The Generation Operators (DefaultIfEmpty, Empty, Range, Repeat) ⌨️ (2:34:43) The Set Operators (Distinct, Except, Intersect, Union) ⌨️ (2:42:59) The Partitioning Operators (Skip, SkipWhile, Take, TakeWhile) ⌨️ (2:47:02) The Conversion Operators (ToList, ToDictionary, ToArray) ⌨️ (2:52:31) The Let and Into Keywords ⌨️ (3:00:25) The Projection Operators (Select, SelectMany) ⌨️ (3:03:46) Course Summary 🎉 Thanks to our Champion and Sponsor supporters: 👾 Nattira Maneerat 👾 Heather Wcislo 👾 Serhiy Kalinets 👾 Erdeniz Unvan 👾 Justin Hual 👾 Agustín Kussrow 👾 Otis Morgan -- Learn to code for free and get a developer job: https://www.freecodecamp.org Read hundreds of articles on programming: https://freecodecamp.org/news ❤️ Support for this channel comes from our friends at Scrimba – the coding platform that's reinvented interactive learning: https://scrimba.com/freecodecamp