LINQ in C#.Net made easy! - PART 3 : Joins in LINQ | Inner Join | Group Join | Left Outer Join

This is the THIRD video of our LINQ in C#.Net series.
In this video you will learn JOINS in LINQ with the help of simple code examples.
00:00 - Intro
00:22 - Joins in LINQ
02:26 - Inner Join
15:23 - Group Join
25:51 - Left Outer Join
If you found this video helpful don’t forget to hit the Like button!
If you wish to join us for future learning, do Subscribe this channel and hit the Bell icon to get the future video notifications!
#LINQ #DotNet
-----------------------------------------------------------------------------------------
We believe in - "Knowledge increases by sharing!!"
Who are we?
We are a bunch of IT professionals who love to teach apart from our regular coding work! 👬👫
Why this Channel?
In our career, we have noticed that many new programmers get confused while coding, even though they are aware of that concept. We help them understand the concept in our office. 🤗
So, we thought why not share these concepts in the same easy to understand way to the whole world.
Let every one who is starting their coding journey get to learn and become a better programmer! 😊
We have taught many people offline, and now trying to make an online presence to help wider audience. 💖
Let's Code!
#LoveForCoding #LoveForTeaching #Codelligent #LetsCode #India
-----------------------------------------------------------------------------------------
Intro music credit: www.zapsplat.com
Intro background image credit: www.freepik.com

[@falanicao2766]

You are a lifesaver! Thanks so much

[@CODELLIGENT]

Glad it was useful. 😊

[@AfrikanBerry]

Thank you alot...please keep making the vids...

[@robimegu3712]

You helped me a lot! Thank you so much!

[@CODELLIGENT]

Glad I could help!

[@bunnyworld5399]

Hi codelligent . Ur Awesome.. clear explanation. U won my subscription. Keep do it

[@CODELLIGENT]

Thanks for the sub! 😊

[@zdkcy2510]

Thanks! Thanks! Thanks! and Many Thanks! I hope that you are in Best of Health!

[@CODELLIGENT]

Thanks a lottt.. Yes I am very much fine. Hope the same with you. :)

[@akatwiggy]

Helped a lot! Thanks!

[@CODELLIGENT]

You're welcome! 😇

[@AfkL-mo5pe]

Thank you very much !!! You video helped me to finally understand LINQ !!!

[@CODELLIGENT]

Glad it helped!

[@Tyronekong]

Great video thank you.

[@CODELLIGENT]

Glad you liked it! 😊

[@sandeepreddy475]

Keep up the good work..!

[@CODELLIGENT]

Thanks a lot..

[@fonskeee]

When using the method linq for the left outer join it is GroupBy instead of join, otherwhise the compiler want recognize the DefaultIfEmpty() method.

[@thechrisgreen]

Is there a way to select all the fields in the join without actually listing them all out manually? Something like SELECT * in SQL.

[@kimicheng5611]

(1) inner join = join non-matching keys will be dropped e.g. Max --> {Thomas, Luise} (2) group join = join + into non-matching keys will be kept in the key list (Ex. Rohan in 22:58) e.g. Max --> {Thomas, Luise} Rohan --> {} (3) left join = join + into + DefaultIfEmpty() non-matching keys will be kept in the key list + an assigned value for every non-matching key e.g.. Max --> {Thomas, Luise} Rohan --> {} After using DefaultIfEmpty() Max --> {Thomas, Luise} Rohan --> Null After using null? "No Students" : students.Name Max --> {Thomas, Luise} Rohan --> "No students" I can be wrong it's just my understanding after watching this video

[@Rahulsingh-rm4iz]

bro make more videos if it is possible for you.

[@gio_hdz]

Where is project file?

[@jaysinghsolanki7094]

how to use joins in web api entity framework ?

[@CODELLIGENT]

LINQ joins work the same way for general Lists or on List of entities. The same concept/syntax you can apply there. Only difference is you will be iterating through an object type (depending on your entity), and when you want to put some conditions inside, you will be doing it using the entity's properties. 😊

[@jaysinghsolanki7094]

@@CODELLIGENT if possible can you please upload a video or contact me at [e-mail] i really need to learn this.