Combining The Results Of Two Linq Queries Into A Single Var?

by

You can only combine enumerations of the same type, you could project both to a common class and then concatenate them:

var result1 = db1.table.Where(a=>a.value>0).Select( x=> new Foo() { /*set props*/ });
var result2 = db2.table.Where(a=>a.value>0).Select( x=> new Foo() { /*set props*/ });

var resultSum = result1.Concat(result2);

More Related Contents:

  1. How to have nested query with LINQ
  2. Convert DateTime to Date string “dd/mm/yyyy”
  3. LEFT OUTER JOIN in LINQ
  4. Check whether an array is a subset of another
  5. Is there a good LINQ way to do a cartesian product?
  6. How do I concatenate two arrays in C#?
  7. Create a list from two object lists with linq
  8. How can I conditionally apply a Linq operator?
  9. LINQ to SQL – Left Outer Join with multiple join conditions
  10. “A lambda expression with a statement body cannot be converted to an expression tree”
  11. Why is .Contains slow? Most efficient way to get multiple entities by primary key?
  12. Proper Linq where clauses
  13. What is the use of Enumerable.Zip extension method in Linq?
  14. Select distinct using linq [duplicate]
  15. How to flatten nested objects with linq expression
  16. TransactionScope vs Transaction in LINQ to SQL
  17. How can I return an anonymous type from a method?
  18. How can I sort a string of text followed by a number using LINQ
  19. Generic All Controls Method
  20. Linq join iquery, how to use defaultifempty
  21. How to convert linq results to HashSet or HashedSet
  22. Why does the Linq Cast helper not work with the implicit cast operator?
  23. Unable to create a constant value – only primitive types
  24. Count property vs Count() method?
  25. Get the index of item in a list given its property
  26. Pair-wise iteration in C#, or sliding window enumerator
  27. Dynamic query with OR conditions in Entity Framework
  28. List.Except is not working
  29. Linq Query keeps throwing “Unable to create a constant value of type System.Object….”, Why?
  30. Only parameterless constructors and initializers are supported in LINQ to Entities message

Leave a Comment