// Returns the tour associated with a given bookmark id. public Tour GetBookmarkTour(Bookmark bookmark) { if (bookmark == null) return null; var bookmarkTour = Database.SqlQuery<Tour>("SELECT * FROM Tours WHERE Id in (SELECT Tour_Id FROM Bookmarks WHERE Id = {0})", bookmark.Id); return bookmarkTour.FirstOrDefault(); }
// Returns the tour associated with a given bookmark id. public Tour GetBookmarkTour(Bookmark bookmark) { if (bookmark == null) return null; IEnumerable<Tour> bookmarkTour = new Tour[0]; try { retryPolicy.ExecuteAction( () => { bookmarkTour = Database.SqlQuery<Tour>("SELECT * FROM Tours WHERE Id in (SELECT Tour_Id FROM Bookmarks WHERE Id = {0})", bookmark.Id); }); } catch (Exception e) { throw e; } return bookmarkTour.FirstOrDefault(); }