' Optimistic concurrency' exception on bool fields

[david.urting]

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

[Shalex]

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

[Shalex]

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.

[Shalex]

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.