title: How to Ignore Case in group by for multiple columns in Linq Query
body: <p>please Find below the sample Query written for fetching data, I am looking for grouping the "GroupName" by ignoring the case of the word.</p>
  
  <p>I am aware of below options and don't want to use these options which gives specific output format. Looking for retaining the original case.</p>
  
  <p>1.TO Lower()
  2.TO Lower()  will be in lower or upper case.</p>
  
  <pre><code>var GroupName = (from p in FilterList
                   where p.GroupName != null
                   group p by new { month = p.ReportedDateTime.Month, year = p.ReportedDateTime.Year, GroupName =p.GroupName  } into d
                   select new
                   {
                       dt = string.Format("{0}/{1}", d.Key.month, d.Key.year),
                           month = d.Key.month,
                           monthName = new DateTime(d.Key.year, d.Key.month, 1).ToString("MMM", CultureInfo.InvariantCulture),
                           count = d.Count(),
                           GroupName = d.Key.GroupName 
                   }).OrderByDescending(g =&gt; g.count)
                     .ThenBy(g =&gt; g.GroupName).Take(20);
  </code></pre>
  
  <p>How can I use "StringComparer.InvariantCultureIgnoreCase" in the above query for the GroupName column.</p>