Lambda Expression for join

by

The lambda for a Join is a bit involved – here’s a simple example:

List<Person> People = new List<Person>();
List<PersonType> PeopleTypes = new List<PersonType>();

var joined = People.Join(PeopleTypes, 
  PeopleKey => PeopleKey.PersonType, 
  PeopleTypesKey => PeopleTypesKey.TypeID, 
  (Person, PersoneType) => new 
    { 
      Name = Person.Name, 
      TypeID = PersoneType.TypeID 
    });

I usually find the query syntax a lot more readable than lambdas for joining

        var joined2 = from p in People
                      join pType in PeopleTypes
                      on p.PersonType equals pType.TypeID
                      where p.Name.StartsWith("whatever")
                      select new { Name = p.Name, TypeID = pType.TypeID };

More Related Contents:

  1. Sorting a list using Lambda/Linq to objects
  2. “Nested foreach” vs “lambda/linq query” performance(LINQ-to-Objects) [closed]
  3. LINQ identity function
  4. System.Linq.Expression.Compile error
  5. Dynamic LINQ OrderBy on IEnumerable / IQueryable
  6. Remove duplicates in the list using linq
  7. Join/Where with LINQ and Lambda
  8. delegate keyword vs. lambda notation
  9. How to perform Join between multiple tables in LINQ lambda
  10. Using the iterator variable of foreach loop in a lambda expression – why fails?
  11. How can I assign a Func conditionally between lambdas using the conditional ternary operator?
  12. Lambda expression not returning expected MemberInfo
  13. Get the property, as a string, from an Expression
  14. How to convert an expression tree to a partial SQL query?
  15. Check if all items are the same in a List
  16. C# => operator?
  17. Cannot convert lambda expression to type ‘string’ because it is not a delegate type [duplicate]
  18. LINQ – Query syntax vs method chains & lambda [closed]
  19. Select distinct by two properties in a list
  20. Can a C# lambda expression have more than one statement?
  21. Lambda Expression using Foreach Clause [duplicate]
  22. Task.Factory.StartNew with async lambda and Task.WaitAll
  23. What does “DisplayClass” name mean when calling lambda?
  24. linq to entities vs linq to objects – are they the same?
  25. C#: Recursive functions with Lambdas
  26. Is there a way to specify an “empty” C# lambda expression?
  27. Task.Run with Parameter(s)?
  28. Getting names of local variables (and parameters) at run-time through lambda expressions
  29. Declaring Func dynamically
  30. How to convert Func to Predicate?

Leave a Comment