public async Task <ActionResult <List <CommodityViewModel> > > Get([FromQuery] CommodityQuery query) { var dbQuery = _commodityRepository.GetQueriable(); if (!string.IsNullOrEmpty(query.SearchTerm)) { dbQuery = dbQuery.Where(x => x.Title.Contains(query.SearchTerm) || x.Code.Contains(query.SearchTerm)); } return(Ok(dbQuery.Pagenate(query).ProjectTo <CommodityViewModel>(_mapper.ConfigurationProvider).ToList())); }