Devart Forums

Hello,

When I set CaseInsensitiveComparison="true", EF5 Update queries on the VARCHAR primary key no longer works.

Here is the query executed:
UPDATE PERSONEXTENDEDFIELDTITLE
SET PERSONEXTENDEDFIELDTITLEVALUE = :p0, LPERSONEXTENDEDFIELDTITLEVALUE = :p1, CREATIONDATE = :p2, MODIFICATIONDATE = :p3
WHERE (ToUpper(PERSONEXTENDEDFIELDTITLENAME)) = (ToUpper(:p4))

Here is the error:
ORA-00904: "TOUPPER": invalid identifier

I'm on devart dotConnect for Oracle Pro v8.2.80, .NET 4.5 and Oracle 11.2.0.3.

I think it's a bug...

Best regards,
Yann

The bug with updating/deleting entity, when its primary key column or concurrency check column is of string type and config.QueryOptions.CaseInsensitiveComparison=True, is fixed. We will notify you when the corresponding build of dotConnect for Oracle is available for download.

New build of dotConnect for Oracle 8.2.90 is available for download!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=28830.