public async Task <IEnumerable <CelestialObjectDto> > Handle(SearchCelestialQuery request, CancellationToken cancellationToken) { var searchResult = await _dataRepo.QueryAsync <CelestialObjectEntityModel>( SqlLoader.GetSql(SqlResourceNames.CelestialObjects.CelestialObject_Search), new { searchText = $"\"{request.SearchText}*\"" }); if (searchResult == null) { return(new List <CelestialObjectDto>()); } return(searchResult.Select(c => _mapper.Map <CelestialObjectDto>(c))); }