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: github.com/GavinLonDigital/Th...
💻 Code Part 2: github.com/GavinLonDigital/LI...
💻 Code Part 3: github.com/GavinLonDigital/LI...
💻 Code Part 4: github.com/GavinLonDigital/LI...
🔗 Full Advanced Course Playlist Link: • Introduction - Advance...
⭐️ 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: www.freecodecamp.org
Read hundreds of articles on programming: freecodecamp.org/news

Пікірлер: 51

  • @GavinLon
    @GavinLon Жыл бұрын

    In this course we look in detail at a set of technologies named LINQ (Language Integrated Query) using the C# language. LINQ is a Microsoft .NET technology that adds querying capability to .NET. LINQ can be likened to SQL but the functionality is executed at a higher level of abstraction. It supports data retrieval from heterogeneous data sources, where queries can be executed directly on for e.g. data collections from within your .NET code. This is a very powerful technology that in my opinion every .NET developer should learn. A special thank you to FreeCodeCamp for sharing this course on the FreeCodeCamp community KZread channel. I hope you enjoy this course and benefit from it.

  • @Alex-yr1jx

    @Alex-yr1jx

    Жыл бұрын

    You’re a legend Gavin, thank you

  • @robinheyer708
    @robinheyer708 Жыл бұрын

    2:31:41 The Enumerable.Empty() method returns an empty sequence of type TResult. It is useful when you need to return an empty sequence of a specific type without creating an instance of a collection. Instantiating an empty list using the List constructor creates an instance of the List class in memory. If you are dealing with a high throughput application, this could have a noticeable impact on performance. Using Enumerable.Empty() does not create an object per call and therefore puts less load on the garbage collector.

  • @Ti_Nspire
    @Ti_Nspire Жыл бұрын

    Beautiful explaination. I use LINQ statements every day for work and this was not explained nearly as in depth during my bachelor's. Thank you

  • @bernpaul9868

    @bernpaul9868

    Жыл бұрын

    same here

  • @vibes992000
    @vibes9920002 ай бұрын

    one of the best tutorials for LINQ. Even as a senior softawre engineer it helped me to recall the concepts.

  • @rahulsbhatt
    @rahulsbhatt Жыл бұрын

    Excellent course! Few months back I had watched his advanced generics series, truly was something I haven't seen on KZread before. Thanks free code camp and Gavin for this masterpiece 🙏

  • @usmanmalik-xk5vi
    @usmanmalik-xk5vi2 ай бұрын

    Excellent resource, The guy is literally breaking examples from Microsoft docs in a much simpler way. Everything you need to know about LINQ is here and that goes for partial entity framework core as well as it heavily uses LINQ about 80% of the time when you are done creating entities and are just working with retrieving them

  • @abdulazeezaare1453
    @abdulazeezaare1453 Жыл бұрын

    I am so excited to be part of this class, thanks

  • @user-mz6kp2oe2o
    @user-mz6kp2oe2o Жыл бұрын

    Perfect! Just perfect! Was worth all the 3 hours of it (although I spent only 2 using INTED))))

  • @dp-bhatt
    @dp-bhatt Жыл бұрын

    This is really a great tutorial on LINQ! ❤❤❤

  • @Bhupatii
    @BhupatiiАй бұрын

    Enjoyed whole tutorial 💡🎉

  • @vijayakumar1591
    @vijayakumar15912 ай бұрын

    Nice! It was a very useful walkthrough code session

  • @chosenireri8443
    @chosenireri8443 Жыл бұрын

    Amazing content

  • @deepakbhagat811
    @deepakbhagat81111 ай бұрын

    best linq tutorial 😌

  • @user-ws4fd4dk4i
    @user-ws4fd4dk4i11 ай бұрын

    best linq content

  • @JoaoBatista-ou3tf
    @JoaoBatista-ou3tf Жыл бұрын

    Great!

  • @sbabymoney3204
    @sbabymoney32042 ай бұрын

    Roland never disappoints!

  • @velovo2988
    @velovo29886 ай бұрын

    Thanks!

  • @junlin9139
    @junlin9139 Жыл бұрын

    Could you please put in a playlist

  • @mustafarahimfandy1660
    @mustafarahimfandy1660 Жыл бұрын

    All you need to know about this framework DataTable , DataRow , DataColumn , DataRelation , and Linq

  • @RaZziaN1

    @RaZziaN1

    Жыл бұрын

    no, u need to know also, authorization attribs, regex, files manipulation, encoding, cqrs approach, ddd, translated enumerations

  • @loool21
    @loool21 Жыл бұрын

    Could you please do a full PHP / Laravel course under 2 hours for beginners?

  • @animeprofiles2077
    @animeprofiles2077 Жыл бұрын

    This was much needed Lmao

  • @Mastermindshares
    @Mastermindshares11 ай бұрын

    Can u make video on Extension method linq query approach . It would be helpful

  • @technicaltechnmofficial2513
    @technicaltechnmofficial2513 Жыл бұрын

    Could you please do a advanced tutorial video on android application development using KOTLIN

  • @bogdanivchenko3723
    @bogdanivchenko37235 ай бұрын

    Inner join query: 1:06:28 left outer join query: 1:16:44

  • @GnomeFire
    @GnomeFire Жыл бұрын

    I'm only in the first lesson, but I'm a bit confused as to why we are adding Employees inside of the GetEmployees function (same with Departments). Wouldn't it be better practice to do that somewhere else in the code so it doesn't run every time we call the function?

  • @robinheyer708

    @robinheyer708

    Жыл бұрын

    I guess it's to simulate a real-life experience where you wouldn't hardcode the list of employees directly into your application but you would keep them in some kind of file or database and make a call to fill the temporary list in your app. Although, essentially, we are actually still hardcoding it here like you noticed ;)

  • @azym_equinox
    @azym_equinox3 ай бұрын

    great

  • @raju.gunawan
    @raju.gunawan Жыл бұрын

    👍👍👍

  • @shuvbhowmickbestin
    @shuvbhowmickbestin Жыл бұрын

    Visual Studio for mac looks more like a text editor than an actual IDE.

  • @soumadip_skyy_banerjee
    @soumadip_skyy_banerjee Жыл бұрын

  • @jasonk6234
    @jasonk6234 Жыл бұрын

    He speaks very clearly but the echoing is very disruptive lol

  • @usmanmarkaz
    @usmanmarkaz Жыл бұрын

    Sir plz upload tutorials and some Projects in React Native from basic to advance

  • @sin7wu
    @sin7wu Жыл бұрын

    please do a video bout TCL?

  • @Ertugrul.Yilmaz
    @Ertugrul.Yilmaz8 ай бұрын

    Is there anyone who watch this video with normal speed?

  • @bojohannesen4352

    @bojohannesen4352

    23 күн бұрын

    Of course. Plenty of time to take notes and appreciate this excellent, free content.

  • @ahmetHoca733
    @ahmetHoca7334 ай бұрын

    Thanks for the video, i guess your success..

  • @mrjoe64-dz4pr
    @mrjoe64-dz4pr Жыл бұрын

    Make video in Adobe Photoshop plzz.

  • @activex7327
    @activex7327 Жыл бұрын

    Code readability is a matter of preference and is context specific. In your example, I could argue either way for LINQ syntax vs Query syntax. Readability is context specific because it depends on the complexity of your data queries. If you want to do simple one line filter, the Query syntax is too verbose where Method syntax is simple and concise. I would be curious who said that Query syntax over Method syntax is preferable ... Because it is a bad recommendation.

  • @rishudev6826
    @rishudev68264 ай бұрын

    Hahah every time he says Func... Definitely sounds like something more obscene

  • @hue_sane
    @hue_sane Жыл бұрын

    ☝️

  • @monoto8272
    @monoto8272 Жыл бұрын

    Datepart() in linq anyone?

  • @Sad_Chief
    @Sad_Chief22 сағат бұрын

    10:00

  • @emeverse
    @emeverse Жыл бұрын

    First to watch and comment

  • @12crenshaw
    @12crenshaw Жыл бұрын

    Why are you obliged to have a cap and be middle aged to programm in c#?

  • @shuvbhowmickbestin

    @shuvbhowmickbestin

    Жыл бұрын

    lmao

  • @cliff_hewitt
    @cliff_hewitt2 күн бұрын

    This guy's jagged narration style is very difficult to follow. Bleh. His coding style also lacks functions, a coding pattern that would be really helpful when dealing with different functionalities in the language.

  • @zlaza314
    @zlaza314 Жыл бұрын

    Hello, i send you a e-mail

  • @arp637
    @arp637 Жыл бұрын

    First