LINQ Join 2 Lists

by

Joins are not so difficult, but your problem could probably use some further explanation.

To join two lists, you could do something like 

var joined = from Item1 in list1
             join Item2 in list2
             on Item1.Id equals Item2.Id // join on some property
             select new { Item1, Item2 };

this will give an IEnumerable<'a>, where ‘a is an anonymous type holding an item from list1 and its related item from list2. You could then choose which objects’ properties to use as needed.

To get the result to a concrete list, all that is needed is a call to .ToList(). You can do that like 

var list3 = joined.ToList();
// or
var list3 = (from Item1 in list1
             join Item2 in list2
             on Item1.Id equals Item2.Id // join on some property
             select new { Item1, Item2 }).ToList();

To do a left join to select all elements from list1 even without a match in list2, you can do something like this 

var list3 = (from Item1 in list1
             join Item2 in list2
             on Item1.Id equals Item2.Id // join on some property
             into grouping
             from Item2 in grouping.DefaultIfEmpty()
             select new { Item1, Item2 }).ToList();

This will give you a list where Item1 equals the item from the first list and Item2 will either equal the matching item from the second list or the default, which will be null for a reference type.

More Related Contents:

  1. System.Linq.Expression.Compile error
  2. Remove duplicates in the list using linq
  3. Sort a list from another list IDs
  4. When to use Cast() and Oftype() in Linq
  5. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  6. How to get index using LINQ? [duplicate]
  7. Using Linq to group a list of objects into a new grouped list of list of objects
  8. Lambda/Linq with Contains criteria for multiple keywords
  9. Entity Framework/Linq EXpression converting from string to int
  10. Error: “The specified LINQ expression contains references to queries that are associated with different contexts”
  11. How to write Asynchronous LINQ query?
  12. JContainer, JObject, JToken and Linq confusion
  13. How do you perform a CROSS JOIN with LINQ to SQL?
  14. LIKE operator in LINQ
  15. Why can’t I call an extension method from a base class of the extended type‏?
  16. Difference between Lookup() and Dictionary(Of list())
  17. Apply function to all elements of collection through LINQ [duplicate]
  18. Generate EF orderby expression by string [duplicate]
  19. Select Multiple Fields from List in Linq
  20. Linq distinct – Count
  21. LINQ – Query syntax vs method chains & lambda [closed]
  22. Resolving extension methods/LINQ ambiguity
  23. How to Quickly Remove Items From a List
  24. Get previous and next item in a IEnumerable using LINQ
  25. How to use LINQ Distinct() with multiple fields
  26. LINQ query to return a Dictionary
  27. LINQ: Select where object does not contain items from list
  28. Sorting a List
  29. linq: order by random
  30. Is Injection Possible through Dynamic LINQ?

Leave a Comment