title: How to use union all in LINQ?
body: <p>How to use union all in LINQ TO SQL.
  I have use the following code for union, then how to use this for union all?</p>
  
  <pre><code>List&lt;tbEmployee&gt; lstTbEmployee = obj.tbEmployees.ToList();
  List&lt;tbEmployee2&gt; lstTbEmployee2 = (from a in lstTbEmployee
                                      select new tbEmployee2
                                      {
                                          eid = a.eid,
                                          ename = a.ename,
                                          age = a.age,
                                          dept = a.dept,
                                          doj = a.doj,
                                          dor = a.dor
  
                                      }).Union(obj.tbEmployee2s).ToList();
  </code></pre>