internal IEnumerable <Location> GetByGeoSearch(double SearchLat, double SearchLong, int MilesDistance, Guid FilterByLocationTypeKey) { CurrentCollection.Clear(); var sql = new Sql(); sql.Select("*") .From <LocationDto>() .Append(GeographyHelper.GetGeoSearchSql(SearchLat, SearchLong, MilesDistance, FilterByLocationTypeKey)); var dtoResult = Repositories.ThisDb.Query <LocationDto>(sql).ToList(); var converter = new DtoConverter(); CurrentCollection.AddRange(converter.ToLocationEntity(dtoResult)); FillChildren(); return(CurrentCollection); }