LINQ Inner-Join vs Left-Join

by

I think if you want to use extension methods you need to use the GroupJoin

var query =
    people.GroupJoin(pets,
                     person => person,
                     pet => pet.Owner,
                     (person, petCollection) =>
                        new { OwnerName = person.Name,
                              Pet = PetCollection.Select( p => p.Name )
                                                 .DefaultIfEmpty() }
                    ).ToList();

You may have to play around with the selection expression. I’m not sure it would give you want you want in the case where you have a 1-to-many relationship.

I think it’s a little easier with the LINQ Query syntax

var query = (from person in context.People
             join pet in context.Pets on person equals pet.Owner
             into tempPets
             from pets in tempPets.DefaultIfEmpty()
             select new { OwnerName = person.Name, Pet = pets.Name })
            .ToList();

More Related Contents:

  1. Prevent duplicates from array, based on condition [closed]
  2. Linq: help me to make this work
  3. When to use .First and when to use .FirstOrDefault with LINQ?
  4. printing all contents of array in C#
  5. What guarantees are there on the run-time complexity (Big-O) of LINQ methods?
  6. Convert string[] to int[] in one line of code using LINQ
  7. LINQ – Left Join, Group By, and Count
  8. Func with out parameter
  9. How to get the index of an element in an IEnumerable?
  10. LINQ: Not Any vs All Don’t
  11. Entity framework left join
  12. How to check if IEnumerable is null or empty?
  13. What is the Efficiency and Performance of LINQ and Lambda Expression in .Net?
  14. Operation could destabilize the runtime?
  15. How to select only the records with the highest date in LINQ
  16. Why is LINQ .Where(predicate).First() faster than .First(predicate)?
  17. MVC 4 how pass data correctly from controller to view
  18. High memory consumption with Enumerable.Range?
  19. How to Get XML Node from XDocument
  20. How to take all but the last element in a sequence using LINQ?
  21. Use linq to generate direct update without select
  22. Cannot implicitly convert type ‘System.Collections.Generic.IEnumerable’ to ‘System.Collections.Generic.List
  23. Is there an IEnumerable implementation that only iterates over it’s source (e.g. LINQ) once?
  24. Find substring in a list of strings
  25. Get List element position in c# using LINQ
  26. Linq – What is the quickest way to find out deferred execution or not?
  27. Linq style “For Each” [duplicate]
  28. How to do an “in” query in entity framework?
  29. LINQ: Add RowNumber Column
  30. Keep Getting ‘The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities’ Exception

Leave a Comment