title: EntityFramework core group by gives me an order by
body: <p>Here is my linq to sql query:</p>
  
  <pre><code>var data = 
      from p in dbcontext.person
      group p by p.city.ToLower() into g
      select new StatsViewModel { city = g.Key, citizen_count = g.Count() };
  </code></pre>
  
  <p>And here is the real sql query i get in sql server:</p>
  
  <pre><code>SELECT [p0].[id_person], [p0]....
        FROM [person] AS [p0]
        ORDER BY LOWER([p0].[city])
  </code></pre>
  
  <p>This is an order by, not a group by...</p>