Support case-insensitive and accent-insensitive text operations, for ex. Contains
Currently case-insensitive text operations for ex. with Contains is not supported.
This is useful in the scenario of a search feature, when we have to find a person by name. The name can contain upper-lower case and accentuated characters that must be handled as a simple character.
At the moment, only a workaround is possible, by executing Oracle-specific commands.
Adriano Labate
shared this idea
-
Shalex
commented
New version of dotConnect for Oracle 6.60 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=22836 . -
Shalex
commented
The possibility to turn off LIKE's ESCAPEs (Oracle, MySQL, PostgreSQL, SQLite) and turn on case insensitive comparison mode (Oracle, PostgreSQL), when using Linq to Entities extention methods .Contains() .EndsWith() .StartsWith(), will be available starting from the next build of dotConnect providers:
var config = Devart.Data.PostgreSql.Entity.Configuration.PgSqlEntityProviderConfig.Instance;
config.QueryOptions.NoEscapeLike = true;
config.QueryOptions.CaseInsensitiveLike = true; -
Adriano Labate
commented
Hello Devart,
Please read the discussion I posted on your forum at http://goo.gl/TV6qc.
I would like to avoid to have proprietary code executed (store commands) before to call comparison methods in order to get case and accent-insensitive comparison.
This could be supported in the canonical method implementation. -
AdminDevart
(_, Devart)
commented
What functionality do you want exactly? If you mean to support such Oracle function as REGEXP_LIKE in LINQ to Entities, it can be done in the nearest future. If you need such functions as NLSSORT, NLS_UPPER и NLS_LOWER, they are already available in LINQ to Entities in the Devart.Data.Entity.Oracle.OracleFunctions class, and in EntitySQL they are available as "Devart.Data.Oracle.NLSSORT". etc.