title: Group By using more than two columns by Lambda expression
body: <p>I have to convert my given linq query in lambda expression. i.e.</p>
  
  <pre><code>var scholars = (from scholar in db.Scholars
                  join suspension in db.Suspensions 
                      on scholar.ID equals suspension.ScholarID
  
                  where suspension.StartDate &gt;= startDate &amp;&amp; 
                        suspension.EndDate &lt;= endDate
  
                  group scholar by new { scholar.ID, scholar.FirstName, scholar.LastName }
                      into g
  
                  select new
                  {
                      FullName = g.Key.FirstName +" " + g.Key.LastName,
                      TotalSuspensionSum = g.Sum(x =&gt; x.Suspensions.Sum(y =&gt; y.SuspensionDays))
                  })
                  .ToList()
                  .OrderBy(x=&gt; x.FullName);
  </code></pre>