title: Entity Framework Core - Skip & Take result in multuple queries with SELECT TOP(1)
body: <p>I'm fetching records from AzureSQL using EF with paging (skip &amp; top).
  Code:</p>
  
  <pre><code>     var query = _context.Kits
              .Include(k =&gt; k.KitStatuses)
              .Where(t =&gt; t.X == y)
              .OrderBy(t =&gt; t.Z)
              .Skip(skip)
              .Take(pageSize).Select(t =&gt; new
              {
                  Id = t.Id,
                  Barcode = t.Barcode,
                ...
              }).ToListAsync();
  </code></pre>
  
  <p>The probelm is that there should be only one query with SELECT TOP(pageSize) but in profiler I can see 1 query per record (on the included KitStatuses table):</p>
  
  <pre><code>exec sp_executesql N'SELECT TOP(1) [k3].[Updated]
  FROM [KitStatuses] AS [k3]
  WHERE ([k3].[Status] = 1) AND (@_outer_Id1 = [k3].[Kit_Id])',N'@_outer_Id1 uniqueidentifier',@_outer_Id1='868780F2-C121-C209-65F1-08D4442D5A8A'
  </code></pre>
  
  <p>Any ideas why?</p>
  
  <p>If I do not include child collection it works fine (1 query).</p>
  
  <p>Thank you &amp; kind regards,
  H3k0</p>