title: How to reverse a paged datasource using EF core?
body: <p>I use the following code to get paged data in the data grid (EF Core 6):</p>
  <pre><code>using (var _sqliteContext = new SQLiteContext())
  {
     AssociatedObject.LoadDynamicItems(e.StartIndex, await _sqliteContext.Equipments
                     .Include(x =&gt; x.CostCenter)
                     .Include(x =&gt; x.EqInfo)
                     .Skip(e.StartIndex)
                     .Take(e.PageSize)
                     .ToListAsync());
  }
  </code></pre>
  <p>I want to reverse the order of the whole data meaning the last data added is shown on the first page by default.
  I tried to use <code>.TakeLast(e.PageSize)</code> but It causes a runtime error and cannot be translated.</p>
  <p>How can I do it?</p>
  <p><strong>Update:</strong>
  I want the newer data to be on the first pages. New data are detected based on incrementing IDs.</p>