robrichhttps://www.woodruff.dev/pagination-in-entity-framework-core-why-skip-take-falls-apart-on-hot-tables/ - #EntityFramework Core skip/take can produce really inefficient queries. "Everything since" is much smoother. Great post https://www.linkedin.com/in/chriswoodruff/.
Pagination in Entity Framework Core: Why Skip/Take Falls Apart on Hot Tables - Chris Woody Woodruff | Fractional Architect
If you've built an ASP.NET Core API or list view backed by Entity Framework Core, you've almost certainly written something like this: var page = await _db.Orders .OrderBy(o => o.Id) .Skip((pageNumber - 1) * pageSize) .Take(pageSize) .ToListAsync(); It works. It matches the page-number UI most users expect. Every EF Core tutorial uses it. It's also
Barret
Alvin Ashcraft 🐿️
