private int FullTextSearch() { _indexFTSBench.Start(); var nameExpr = Expression.Property("Name"); var index = Index.FullTextIndex().On(FullTextIndexItem.Expression(nameExpr)); Db.CreateIndex("nameFTS", index); _indexFTSBench.Stop(); var ARTIST = Expression.Property("Artist"); var ALBUM = Expression.Property("Album"); var NAME = Expression.Property("Name"); var results = new List <string>(); using (var q = Query.Select(SelectResult.Expression(ARTIST), SelectResult.Expression(ALBUM), SelectResult.Expression(NAME)) .From(DataSource.Database(Db)) .Where(NAME.Match("'Rock'")) .OrderBy(Ordering.Property("Artist"), Ordering.Property("Album"))) { _queryFTSBench.Start(); using (var rows = q.Execute()) { foreach (var row in rows) { results.Add(row.GetString(2)); } } } _queryFTSBench.Stop(); results.Count.Should().Be(30); return(results.Count); }