/// <inheritdoc /> public Task <PageResponse <HouseInfoDto> > GetPage(PageRequest <HouseFilter> request) { using (var db = new ApplicationDbContext()) { var dbResult = db.Houses .Include(h => h.Subnet) .AsQueryable(); dbResult = Filter(request, dbResult); dbResult = Sort(request, dbResult); var total = dbResult.Count(); dbResult = dbResult.Skip(request.Skip).Take(request.Limit); var result = new PageResponse <HouseInfoDto> { Data = _mapper.ToInfoDto(dbResult), Total = total }; return(Task.FromResult(result)); } }