[#Script #Coding] Advanced C# – LINQ Tutorial

Posted on Monday May 8, 2023 by Eric Brooks

Spread the love

Advanced C# – LINQ Tutorial

By freeCodeCamp.org
Published: Apr 06, 2023

“
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

[READ MORE]

”

Spread the love

Proudly powered by WordPress

EricBrooks.Com^® is licensed under a Creative Commons License.

Disclaimer: The views expressed herein are solely those of Eric Brooks. They do not necessarily reflect those of his employers, friends, contacts, family, or even his pets (though my cat, Puddy, seems to agree with me on many key issues.). In accordance to my terms of use, you hereby acknowledge my right to psychoanalyze you, practice accupuncture, and mock you incessantly with every visit. As the user, you also acknowledge that the author has been legally declared a "Problem Adult" by the Commonwealth of Pennsylvania, and is therefore not responsible for any of his actions. ALSO, the political views and products advertised on this site may/may not reflect the views of Puddy or myself, so please don't take them as an endorsement. We just need to eat.

Connect