It seems Query.FreeText<t>() lacks a functionality of DO 3.X: Search with an * to match words starting by a value.

Example : If I have in my index:

• text1
• text2

Query.FreeText<t>("text") will get no result : this is normal. Query.FreeText<t>("text*") will get no result : worked in DO3.X

Is it possible to add this feature?

PS: Query.FreeText<t>("*text") could be a good idea ;)

PPS: Query.FreeText<t> don't work :

• if you use the entity in a Where clause (ArgumentException)
• if you use a type T that is not the one that has the ft index but a sub class

I've a sample if you want one.

Updated at 26.04.2010 8:32:02

Here comes the sample : [attachment=0:33qgsq5l]DoFullText.zip[/attachment:33qgsq5l]

There are working requests samples, one sample that does not returns what I want (with *), some throwing exceptions (not surprisingly when you know the sql below)

This thread was imported from our support forum. The original discussion may contain more detailed answer.