What's the best pagination approach?
It depends on your dataset.
The standard pagination approach is offset pagination.
You skip a certain number of rows and take the rows you need after that.
Offset pagination works great for smaller datasets or when you only access the first few pages.
But it becomes slower for "deep" pages, further away from the start.
Luckily, there's another approach.
It's called Keyset pagination or cursor pagination.
It uses an index to perform a seek operation to the start of the requested page.
You always need to remember the last Key you fetched and use it when querying for the next page.
The key is typically a serial ID column or a timestamp.
A good example of using keyset pagination is your email inbox.
You can see the latest emails and go to the next or previous page.
Another great use case is "infinite scroll" for timelines or similar UIs.
Here's an EF Core feature that can help you implement this: https://t.co/G1cIPADJj0
Learn how to export a DataTable to CSV using a C# extension method. Boost your C# skills with this practical guide. #DEVCommunity#dotNET
https://t.co/jCKd7ubt2q
“eu sou tímido por isso não passo em entrevista” “não sei como me vender” “eu nao sei se sou bom para essa área” TUDO é aprendido mas sua falta de vontade e incapacidade de lidar com desconfortos não te permite sair da mediocridade.
Pra desenvolvedores @dotnet Blazor é um baita framework que casou perfeitamente a linguagem.
Não trabalho com dotnet há anos (2016)
Me falaram que tá uma delicia programar em C# .NET e ainda continua sendo uma das linguagens com maior demanda no mercado
cc: @mairacw
New to C# and .NET? Dive into this introductory guide. Learn how they work together to simplify app development across platforms.
{ author: @DotNetDevABP } #DEVCommunity#dotNET
https://t.co/5ZEG8IGghK