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
CaseInsensitiveComparison BUG with VARCHAR Key
-
- Posts: 2
- Joined: Tue 21 Aug 2012 08:39
Re: CaseInsensitiveComparison BUG with VARCHAR Key
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.
Re: CaseInsensitiveComparison BUG with VARCHAR Key
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.
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.