Page 1 of 1

Problem with bool WHERE clause in EFCore

Posted: Thu 22 Sep 2016 13:59
by seb1487
Hi Shalex,
dotConnect throws an error on an boolean Query like this:

Code: Select all

_dbContext.Class1.Any(o => o.MyBoolProp)
Generated SQL:

Code: Select all

SELECT CASE
    WHEN EXISTS (
        SELECT 1
        FROM "Class1" "o"
        WHERE "o"."MyBoolProp")
    THEN 1 ELSE 0
END
FROM DUAL

Re: Problem with bool WHERE clause in EFCore

Posted: Fri 23 Sep 2016 18:28
by Shalex
Thank you for your report. We have reproduced the issue and are investigating it. We will notify you about the result.

Re: Problem with bool WHERE clause in EFCore

Posted: Thu 06 Oct 2016 16:13
by Shalex
The bug with comparing bool class property with some value in EF Core is fixed: viewtopic.php?f=1&t=34384.