How can I do a Union all in Entity Framework LINQ To Entities?
49,028
Solution 1
Here is the answer you are looking for. Use the Concat keyword.
From the example:
var query = (from x in db.Table1 select new {A = x.A, B = x.B})
.Concat( from y in db.Table2 select new {A = y.A, B = y.B} );
Solution 2
I believe Concat
is what you're looking for.
var allResults = resultSet1.Concat(resultSet2);
Obviously, both result sets must use the same type. And I believe there my be other requirements about how the result sets are constructed in the first place, but I don't know all the details.
Author by
Rami Sakr
Updated on March 23, 2020Comments
-
Rami Sakr about 4 years
I came across a scenario where I had to use Union all, how can I achieve so in LINQ to entities ?
-
SteveB about 5 yearsThis is great. I mistakenly used query1.Union(query2). Seems logical, right?