title: How can convert SQL to lambda or LINQ
body: <p>How can I convert below SQL to lambda or LINQ?</p>
  <pre class="lang-sql prettyprint-override"><code>with cte
  as (select * from test1
      union all
      select * from test2)
  
  select * from cte
  union all 
  select sum(columnA),sum(columnB),sum(columnC) from cte
  </code></pre>