How to perform Join between multiple tables in LINQ lambda

by

For joins, I strongly prefer query-syntax for all the details that are happily hidden (not the least of which are the transparent identifiers involved with the intermediate projections along the way that are apparent in the dot-syntax equivalent). However, you asked regarding Lambdas which I think you have everything you need – you just need to put it all together.

var categorizedProducts = product
    .Join(productcategory, p => p.Id, pc => pc.ProdId, (p, pc) => new { p, pc })
    .Join(category, ppc => ppc.pc.CatId, c => c.Id, (ppc, c) => new { ppc, c })
    .Select(m => new { 
        ProdId = m.ppc.p.Id, // or m.ppc.pc.ProdId
        CatId = m.c.CatId
        // other assignments
    });

If you need to, you can save the join into a local variable and reuse it later, however lacking other details to the contrary, I see no reason to introduce the local variable.

Also, you could throw the Select into the last lambda of the second Join (again, provided there are no other operations that depend on the join results) which would give:

var categorizedProducts = product
    .Join(productcategory, p => p.Id, pc => pc.ProdId, (p, pc) => new { p, pc })
    .Join(category, ppc => ppc.pc.CatId, c => c.Id, (ppc, c) => new {
        ProdId = ppc.p.Id, // or ppc.pc.ProdId
        CatId = c.CatId
        // other assignments
    });

…and making a last attempt to sell you on query syntax, this would look like this:

var categorizedProducts =
    from p in product
    join pc in productcategory on p.Id equals pc.ProdId
    join c in category on pc.CatId equals c.Id
    select new {
        ProdId = p.Id, // or pc.ProdId
        CatId = c.CatId
        // other assignments
    };

Your hands may be tied on whether query-syntax is available. I know some shops have such mandates – often based on the notion that query-syntax is somewhat more limited than dot-syntax. There are other reasons, like “why should I learn a second syntax if I can do everything and more in dot-syntax?” As this last part shows – there are details that query-syntax hides that can make it well worth embracing with the improvement to readability it brings: all those intermediate projections and identifiers you have to cook-up are happily not front-and-center-stage in the query-syntax version – they are background fluff. Off my soap-box now – anyhow, thanks for the question. 🙂

More Related Contents:

  1. Join/Where with LINQ and Lambda
  2. System.Linq.Expression.Compile error
  3. Get All instead of FirstOrDefault
  4. LEFT OUTER JOIN in LINQ
  5. How to do joins in LINQ on multiple fields in single join
  6. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  7. How can I get every nth item from a List?
  8. Sorting a list using Lambda/Linq to objects
  9. How do I invoke an extension method using reflection?
  10. The type of one of the expressions in the join clause is incorrect in Entity Framework
  11. Mutating the expression tree of a predicate to target another type
  12. LINQ: combining join and group by
  13. Can I specify my explicit type comparator inline?
  14. Multiple Order By with LINQ [duplicate]
  15. lambda expressions in immediate window for VS2015
  16. Is it Linq or Lambda?
  17. C# Pass Lambda Expression as Method Parameter
  18. Cannot use a lambda expression as an argument to a dynamically dispatched operation without first casting it to a delegate or expression tree type
  19. LINQ – Query syntax vs method chains & lambda [closed]
  20. Local variable and expression trees
  21. How to merge a list of lists with same type of items to a single list of items?
  22. How to check for nulls in a deep lambda expression? [duplicate]
  23. String.IsNullOrWhiteSpace in LINQ Expression
  24. convert this LINQ expression into Lambda
  25. Access the value of a member expression
  26. List complex sorting
  27. How do I dynamically create an Expression predicate?
  28. Select all columns after JOIN in LINQ
  29. Is it possible to perform joins across different databases using LINQ?
  30. Convert DataTable to Generic List in C#

Leave a Comment