Hi,
I'm trying to use FullTextSearch with LLBLGen.
LLBLGen query code:
IPredicateExpression filter = new PredicateExpression();
filter.Add(new FieldFullTextSearchPredicate(Table1Fields.Value, FullTextSearchOperator.Contains, *input + ""));
var collection = new Table1Collection();
collection.GetMulti(filter)
I'm doing a search by email: "firstname.lastname@domain.com"
Results is very strange:
1. Input pattern: "firstname." + "". LLBLGen result: success
2. Input pattern: "firstname.l + "". LLBLGen result: success
3. Input pattern: "firstname.las" + "". LLBLGen result: fail. Email "firstname.lastname@domain.com" not found.
4. Input pattern: "firstname.lastname" + "". LLBLGen result: success
Generated Sql query is:
SELECT [Table1].[Id], [Table1].[Created], [Table1].[Value] FROM [Table1] WHERE ( Contains([Table1].[Value], @p1))
Parameter: @p1 : String. Length: 15. Precision: 0. Scale: 0. Direction: Input. Value: "firstname.las*".
If execute a query to the database, the email will find. Looks like LLBLGen is missing a character '*'
Could anyone help me?