title: How to identify duplicates in EF Core 3.1
body: <p>The problem is as follow:</p>
  
  <p>I have updated project to EF Core 3.1
  My code to show duplicate email addresses in companies data base  stopped working.
  This code no longer works after update:</p>
  
  <pre><code>cos = cos.Where(x =&gt; !string.IsNullOrEmpty(x.Email)).GroupBy(c =&gt; c.Email).Where(c =&gt; c.Count() &gt; 1).SelectMany(grp =&gt; grp);
  
  return View(await cos.ToListAsync());
  </code></pre>
  
  <p>I thinks this is the problem:</p>
  
  <p>Before EF Core 3.0, this was done implicitly, so EF downloaded all result rows and then applied the LINQ GroupBy. However, this implicit behavior might let the programmer expect that the entire LINQ query is executed in SQL, with potentially enormous performance impact when the result set is rather large. For this reason, implicit client side evaluation of GroupBy was disabled completely in EF Core 3.0.</p>
  
  <p>Do you know how to modify a.m. code to work with EF Core 3.1?
  Thank you for your help.</p>