title: EF Core - How to Include child but limit the number of child entities returned
body: <p>I am using .NET Core 3.1. I have a parent with thousands of child elements, but I only want to retrieve the latest 10 children (and later will use pagination). When I run the following query:</p>
  <pre><code>context.Parent.Include(p =&gt; p.Child)
  </code></pre>
  <p>it will return all children and is incredibly slow. How can I return only 10 children and later use it for pagination? EF prevents using lambdas inside the Include, for example <code>context.Parent.Include(p =&gt; p.Child.Take(10))</code> throws an exception.</p>
  <p>Do I need multiple calls to the DB?</p>