public override IEnumerable <string> Query(JournalPageIdsFromSearch query) { var search = query.Search; var searchTerms = search.SearchTerms; if (!searchTerms.Any()) { return(Enumerable.Empty <string>()); } var queryOperator = search.MatchAny ? "OR" : "AND"; var likeOperator = search.MatchCase ? "GLOB" : "LIKE"; var wildcard = search.MatchCase ? "*" : "%"; var sql = string.Format("SELECT jp.Id FROM JOURNAL_PAGES jp {0}", whereCondition(searchTerms, queryOperator, likeOperator, wildcard)); return(Db.Query <string>(sql)); }