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!

[@psychologically_shaken]

You are a lifesaver! Thanks so much

[@CODELLIGENT]

Glad it was useful. 😊

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

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

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

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

[@Rahulsingh-rm4iz]

bro make more videos if it is possible for you.

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

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

[@gio_hdz]

Where is project file?