public async Task <SearchTransactionResult> Handle(SearchTransaction message, CancellationToken cancellationToken) { var rows = (await queryBuilder .Query(message.UserId, message.Filter)) .OrderByDescending(t => t.Row.Date) .ToList(); var pagination = PaginationResult.CreateFromTotal(message.PageFilter.PageSize, message.PageFilter.Page, rows.Count); //var result = rows // .Skip(pagination.PageSize * (pagination.CurrentPage - 1)) // .Take(pagination.PageSize) // .ToList(); return(new SearchTransactionResult(rows, pagination)); }