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();