title: How to get random records in Pomelo.EntityFrameworkCore.MySql?
body: <p>I'm currently using this method:</p>
  
  <pre><code>.OrderBy(s =&gt; Guid.NewGuid())
  .Take(10)
  ...
  </code></pre>
  
  <p>But then I noticed a warning in my logs:</p>
  
  <pre><code>The LINQ expression 'orderby NewGuid() asc' could not be
  translated and will be evaluated locally.
  </code></pre>
  
  <p>I'm using Pomelo.EntityFrameworkCore.MySql 1.1.1</p>