How can I do a Union all in Entity Framework LINQ To Entities?

c# linq tsql entity-framework-4 union-all
Rami Sakr picture Rami Sakr · Mar 22, 2012 · Viewed 45.4k times · Source

I came across a scenario where I had to use Union all, how can I achieve so in LINQ to entities ?

Answer

Justin Pihony picture Justin Pihony · Mar 22, 2012

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} );

Related questions

SQL LIKE in Linq

Before adding this question, I did search on stackoverflow for similar ones but I couldnt find. Most of the questions over internet were using LIKE with a string (for eg LIKE '%ABC%') but I need to compare with …

Read More
Group by in LINQ

Let's suppose if we have a class like: class Person { internal int PersonID; internal string car; } I have a list of this class: List<Person> persons; And this list can have multiple instances with same PersonIDs, for example: …

Read More
LINQ query on a DataTable

I'm trying to perform a LINQ query on a DataTable object and bizarrely I am finding that performing such queries on DataTables is not straightforward. For example: var results = from myRow in myDataTable where results.Field("RowNo") == 1 select results; This …

Read More