I have a string property in my model that can contain underscores (_). So I don't want _ treated as an wildcard character in my search. I followed option 1 posted here and set
Code: Select all
var config = Devart.Data.Oracle.Entity.Configuration.OracleEntityProviderConfig.Instance;
config.QueryOptions.NoEscapeLike = true;
Code: Select all
expressions.Add(request => request.RequestNo.StartsWith(filter.RequestNo));
Code: Select all
WHERE ("Extent1"."RequestNo" LIKE :p__linq__0 ESCAPE '/')
The problem comes here:
When I set
Code: Select all
expressions.Add(request => request.RequestNo.ToLower().StartsWith(filter.RequestNo.ToLower()));
Code: Select all
WHERE (LOWER("Extent1"."RequestNo") LIKE LOWER(:p__linq__0) || '%')
Is this a bug or desired bahaviour?
Is there a way to achieve my goal without the .ToLower().StartWith()?
I am using Devart.Data.Oracle Version 9.1.131.0, together with Entity Framework 6.0.
Greetings
Peter