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!

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

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

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

[@akatwiggy]

Helped a lot! Thanks!

[@CODELLIGENT]

You're welcome! 😇

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

[@bunnyworld5399]

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

[@CODELLIGENT]

Thanks for the sub! 😊

[@Tyronekong]

Great video thank you.

[@CODELLIGENT]

Glad you liked it! 😊

[@AfrikanBerry]

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

[@sandeepreddy475]

Keep up the good work..!

[@CODELLIGENT]

Thanks a lot..

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