CODEWITHSUNDEEP
c#linqfull-text-searchravendbcontains
Algirdas
Algirdas

Reputation: 1115

C# implement raven db full text search by the part of word

I have a grid and I need to support full text search. I need to support search not only by start with and end with, but I need to support search by the part of word. For example if I have "MyWord", I need that search will found by the part of "wor". If I try to use string.contains() I get the following error:

Contains is not supported, doing a substring match over a text field is a very slow operation, and is not allowed using the Linq API.
The recommended method is to use full text search (mark the field as Analyzed and use the Search() method to query it.

If I build raven db index and mark field as Analyzed, contains is not working. It works with StartWith() and EndWith(), but not with contains. Using .Search() I'm getting the same results. Another option is to use lucene syntax:

.Where("Name:*partOfWord*")

and it works fine, but I don't want to combine linq with lucene syntax and I want to solve it using raven db indexes.

Have you any ideas how to implement full text search for raven db using indexes?

Upvotes: 1

Views: 1922

Answers (2)

user1797792
user1797792

Reputation: 1189

I use this query to search for persons full names by just typing a part of the name. It is recommended to set a minimum length of search string.

.Search(x => x.Name, "word to search" + "*", escapeQueryOptions: EscapeQueryOptions.AllowPostfixWildcard)

Upvotes: 1

Hannes Johansson
Hannes Johansson

Reputation: 1802

You want to be using an NGram analyzer, as described here. It's an analyzer you can add to your RavenDB server by dropping its DLL in the Analyzers folder.

You really don't want to do any *substr Lucene queries ("ending with" clauses, that is), because the performance is terrible. The inconsistency in coding style is a lesser problem.

Upvotes: 2

Related Questions