title: Does Entity Framework Core support Union?
body: <p>I am trying to query multiple tables in EF Core using union as below, but it does not allow. Please find the query and also attached the image on the error hint that .net core frame work provides.</p>
  
  <pre><code> var query =
                  _context.Brand.Select(x =&gt; new { BrandID = x.Brandid })
                      .Union(_context.Factory.Select(x =&gt; new { Fa = x.Factorycode }))
                      .Union(_context.Brandfactory.Select(x =&gt; new { BrFc = x.Factoryid }));
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/PishS.png" rel="nofollow noreferrer">enter image description here</a></p>