(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
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. 😊
Thank you very much !!! You video helped me to finally understand LINQ !!!
Glad it helped!
Thanks! Thanks! Thanks! and Many Thanks! I hope that you are in Best of Health!
Thanks a lottt..
Yes I am very much fine. Hope the same with you. :)
You are a lifesaver! Thanks so much
Glad it was useful. 😊
When using the method linq for the left outer join it is GroupBy instead of join, otherwhise the compiler want recognize the DefaultIfEmpty() method.
You helped me a lot! Thank you so much!
Glad I could help!
Great video thank you.
Glad you liked it! 😊
Helped a lot! Thanks!
You're welcome! 😇
Hi codelligent . Ur Awesome.. clear explanation. U won my subscription.
Keep do it
Thanks for the sub! 😊
(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
Thank you alot...please keep making the vids...
Is there a way to select all the fields in the join without actually listing them all out manually? Something like SELECT * in SQL.
Keep up the good work..!
Thanks a lot..
how to use joins in web api entity framework ?
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. 😊
@@CODELLIGENT if possible can you please upload a video or contact me at jaysinghsolanki65@gmail.com i really need to learn this.
bro make more videos if it is possible for you.
Where is project file?