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)));
}
