Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
The quickest way is to make an equal join on two anonymous objects: var result = from x in entity join y in entity2 on new { x.field1, x.field2 } equals new { y.field1, y.field2 } Ano...
Answer
#1: Initial revision
by
Alexei
·
2020-09-15T15:28:27Z (about 4 years ago)
The quickest way is to make an equal join on two anonymous objects:
var result = from x in entity
join y in entity2 on new { x.field1, x.field2 } equals new { y.field1, y.field2 }
Another way is combine the styles of writing the LINQ statements for more flexibility:
var result = from x in entity1
from y in entity2
.Where(y => y.field1 == x.field1 && y.field2 == x.field2)
This allows for more complex JOIN operations and can be easily transformed into a LEFT JOIN by simply adding a `.DefaultIfEmpty()` at the end.