title: LINQ Lambda Group By with Sum
body: <p>Hi I can do this in method syntax but I'm trying to improve my lambda skills how can I do:</p>
  
  <pre><code>SELECT SUM([job_group_quota]) as 'SUM'
  FROM [dbo].[tbl_job_session]
  WHERE [job_group_job_number] = @jobnum
  and [job_group_ID] like @sess
  GROUP BY [job_group_job_number]
  </code></pre>
  
  <p>I've been messing around with it but can't get it right.</p>
  
  <pre><code>lnq.tbl_job_sessions.GroupBy(a =&gt; a.job_group_job_number == jnum)
                      .Select(b =&gt; new { b.job_group_quota}).Sum();
  </code></pre>