title: IGrouping<T,T> does not contain a definition of Leave
body: <p>I am using <code>concat</code>. Following is my <code>relevant</code> code, it gives me Error in Linq <code>Select new</code> 1st Option <code>Leave</code>. I want to convert the SQL Query in Linq.</p>
  
  <pre><code>Select Code,Sum(DAYS) as DAYS,LEAVE  from 
  (SELECT CODE,SUM(DAY) AS DAYS,LEAVE FROM LV1
  WHERE DATE&gt;='01-Jan-12' AND CODE='1' 
  GROUP BY CODE,LEAVE
  Union ALL
  select CODE,SUM(DAYS1),Leave from LV2 WHERE
  and code= '1' 
  GROUP BY CODE,LEAVE) A 
  Group by LEAVE,Code
  </code></pre>
  
  <p>Error in Code :-</p>
  
  <pre><code>var data = ctx.tblLV1.Where(m =&gt; m.Code == "1" &amp;&amp; m.Date &gt;= fromDate)
                       .GroupBy(m =&gt; m.Leave)
                       .Select(m =&gt; new
                              {      
                                 Leave = m.Leave, 
                                 Days = m.Sum(k =&gt; k.Days)
                               })
                        .Concat(
                        ctx.tblLV2.Where(m =&gt; m.Code == "1")
                                  .GroupBy(m =&gt; m.Leave)
                                  .Select(m =&gt; new
                                           {                        
                                               Leave = m.Leave,
                                               Days = m.Sum(k =&gt; k.Days1)
                                           }));
  
                          //var data = data.GroupBy(m=&gt;m.Leave).
  </code></pre>