Select all columns after JOIN in LINQ

by

You have to specify each manually if you want to project into a flattened type. Your other option is to just have your combined type contain both objects, and the objects will naturally bring along their properties. 

select new 
{
    Object1 = object1,
    Object2 = output
};

And you would work with it like myObj.Object1.Property1, myObj.Object2.Property4, etc.

One final option that still involves some manual work is to define an appropriate type and have a constructor or a builder method that does the work of segmenting out your object properties into a flattened type. You still perform the manual mapping, but you isolate it from your query logic.

select new CombinedType(object1, output);
//or 
select builder.GetCombinedType(object1, output);

More Related Contents:

  1. LEFT OUTER JOIN in LINQ
  2. Join/Where with LINQ and Lambda
  3. How to do joins in LINQ on multiple fields in single join
  4. Unable to create a constant value of type Only primitive types or enumeration types are supported in this context
  5. How to perform Join between multiple tables in LINQ lambda
  6. The type of one of the expressions in the join clause is incorrect in Entity Framework
  7. LINQ join two DataTables
  8. How to get values from IGrouping
  9. LINQ: combining join and group by
  10. Is it possible to perform joins across different databases using LINQ?
  11. Convert DateTime to Date string “dd/mm/yyyy”
  12. Is there a good LINQ way to do a cartesian product?
  13. Create a list from two object lists with linq
  14. How can I conditionally apply a Linq operator?
  15. LINQ Contains Case Insensitive
  16. Entity Framework/Linq EXpression converting from string to int
  17. Differences between IQueryable, List, IEnumerator?
  18. Difference between Lookup() and Dictionary(Of list())
  19. How to convert an expression tree to a partial SQL query?
  20. How to convert linq results to HashSet or HashedSet
  21. Unable to create a constant value – only primitive types
  22. Check for any element that exists in two collections
  23. Getting odd/even part of a sequence with LINQ
  24. C# Is there a LINQ to HTML, or some other good .Net HTML manipulation API?
  25. What does this C# code with an “arrow” mean and how is it called?
  26. Dynamic query with OR conditions in Entity Framework
  27. Finding symmetric difference with LINQ
  28. AutoMapper for Func’s between selector types
  29. Select multiple fields group by and sum
  30. Linq – Top value from each group

Leave a Comment