Devart Forums

Hi,

we have an 'optimistic concurrency' issue with version 8.4 of dotConnect for Oracle on entity fields of type bool. This issue does not occur with version 7.1.

Case:
- Tools/frameworks: Visual Studio 2013 Update 4, .NET FW 4.5/EDMX 3.0, Devart 8.4.215.0, Entity Framework 5 (code generation strategy 'Legacy ObjectContext'), Oracle 11g2.
- A table with a IS_TRUE NUMBER(1,0) column that is mapped on a bool property. The entity inherits EntityObject (legacy).
- The Concurrency Mode on that column is 'Fixed'.
- When updating an entity that has IS_TRUE = 1 as old value AND as new value, an 'OptimisticConcurrencyException' is thrown.
- The DBMonitor shows that the old value is 0 (this should be 1).

If necessary I can provide a VS2013 solution that reproduces the case.

Is this a bug?

greetings,
David

We have reproduced the issue and are investigating it. As soon as we have any results, we will let you know.

The bug with generating SQL for the INSERT / UPDATE / DELETE operations when using bool property mapped to Number(1,0) 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.4.379 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=31498.