Hi studiosoft,
I remember another guy asking this, but I can't find his post.
So anyway... I don't know what Database are you using. For T-SQL the LIKE syntax is:
match_expression [ NOT ] LIKE _pattern _[ ESCAPE escape_character ]
where _pattern _ Is the specific string of characters to search for in match_expression, and can include the following valid wildcard characters. pattern can be a maximum of 8,000 bytes.
From that and from my LLBLGen tests I think that's not possible for the moment (I haven't tried with LINQ2LLBL at LLBLGenPro v2.6Beta).
What I could recommend you as a workaround (assuming you are using SQLServer) is rewrite your query like this:
WHERE CHARINDEX( [field], 'some string value') = 1
This has the same efect and nearly identical performance (no tested with large amount of data).
This is how your code would looks like (using Adapter):
DbFunctionCall fnChrInx = new DbFunctionCall("CHARINDEX", new object[] { SomeTableFields.SomeField, "some string value"});
IPredicateExpression filter = new PredicateExpression();
filter.Add(SomeTableFields.SomeField.SetExpression(fnChrInx) =1);
