I've problem with a boolean value in a Oracle database, entity framework and dotconnect (Version 7.9.333) Here is a description:
The table: TEST
ID Numeric(11,0)
IsValid Numeric(1, 0)
In the field IsValid is saved 0 for false and -1 for true.
The following code works fine:
Code: Select all
For each item in ctx.TESTs
if item.IsValid then 'IsValid return true and fals correctly
'do something
end if
next
Code: Select all
For each item in ctx.TESTs.where(function(p) p.isValid)
if item.IsValid then
'do something
end if
next
Code: Select all
SELECT
"Extent1".ID,
"Extent1".ISVALID,
FROM TEST "Extent1" WHERE ("Extent1".ISVALID = 1)
...where ISVALID <> 0
Does someone have a solution for the problem or have we to change the database values
from -1 to 1. That will bring huge effort for us, because we have a lot of old applications
with sql like value = -1.
Best regards, Ansgar