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

[@AfkL-mo5pe]

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

[@CODELLIGENT]

Glad it helped!

[@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

[@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. :)

[@psychologically_shaken]

You are a lifesaver! Thanks so much

[@CODELLIGENT]

Glad it was useful. 😊

[@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.

[@robimegu3712]

You helped me a lot! Thank you so much!

[@CODELLIGENT]

Glad I could help!

[@AfrikanBerry]

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

[@bunnyworld5399]

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

[@CODELLIGENT]

Thanks for the sub! 😊

[@akatwiggy]

Helped a lot! Thanks!

[@CODELLIGENT]

You're welcome! 😇

[@Tyronekong]

Great video thank you.

[@CODELLIGENT]

Glad you liked it! 😊

[@sandeepreddy475]

Keep up the good work..!

[@CODELLIGENT]

Thanks a lot..

[@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.

[@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.

[@Rahulsingh-rm4iz]

bro make more videos if it is possible for you.

[@gio_hdz]

Where is project file?