0

I would like to implement cursor based pagination using uniqueidentifier column in SQL Server. Is there any way to make this query to run server-side with Entity Framework Core?

var cursor = Guid.NewGuid();
// This query will not delegate filtering to database
var items = await dbContext.Items.Where(x => x.Id.CompareTo(cursor) > 0).ToListAsync();

0 Answers0