// for test purposes only. normally you would add arguments here (request/query)
public IPagedResult <TestEntity> FindPaged(int offset, int pageSize)
=> EntityRetriever.FindPaged(new PagedSelectCommandBuilder()
.Select("*")
.From("MyTable")
.OrderBy("Name")
.Skip(offset)
.Take(pageSize)
.Build());
public IPagedResult <TEntity> FindAllPaged(int offset, int pageSize) => EntityRetriever.FindPaged(PagedEntitySelectCommandProvider.CreatePaged <TEntity>(DatabaseOperation.Select, offset, pageSize));
