title: Taking union of two lists of IEnumerable and IQueryable
body: <p>Hi I have two tables tabl1 and table2. I am trying search the each table for certain date once i get lists c1 and c2 then I need to get union of the two, so I have one distinct list with no repeating rows using entity framework.</p>
  
  <pre><code>  ssEntities sss = new ssEntities();
    var c1 = sss.table1.ToList().Where(x =&gt; x.date &gt;= DateTime.Today);
    var c2=sss.table2.ToList().Where(x=&gt;x.date1 DateTime.Today);
    var ll=c1.Union(c2).ToList();
  </code></pre>
  
  <p>When I try to take union of the two lists I get error given below</p>
  
  <pre><code>Instance argument: cannot convert from 
  'System.Collections.Generic.IEnumerable&lt;testproject.table1&gt;' to   'System.Linq.IQueryable&lt;testproject.table2&gt;'
  </code></pre>
  
  <p>Please help.</p>