dotConnect throws an error on an boolean Query like this (Oracle 10):
Code: Select all
dbContext.Class1.Any(o => o.MyBoolProp);
'ORA-00920: invalid relational operator'
Generated SQL:
Code: Select all
SELECT CASE
WHEN EXISTS (
SELECT 1
FROM "Class1" "o"
WHERE "o"."MyBoolProp")
THEN 1 ELSE 0
END
FROM DUAL