Problem with bool WHERE clause in EFCore

Problem with bool WHERE clause in EFCore

Postby seb1487 » Thu 22 Sep 2016 13:59

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
seb1487
 
Posts: 16
Joined: Fri 24 Jun 2016 10:27

Re: Problem with bool WHERE clause in EFCore

Postby Shalex » Fri 23 Sep 2016 18:28

Thank you for your report. We have reproduced the issue and are investigating it. We will notify you about the result.
Shalex
Devart Team
 
Posts: 7473
Joined: Thu 14 Aug 2008 12:44

Re: Problem with bool WHERE clause in EFCore

Postby Shalex » Thu 06 Oct 2016 16:13

The bug with comparing bool class property with some value in EF Core is fixed: http://forums.devart.com/viewtopic.php?f=1&t=34384.
Shalex
Devart Team
 
Posts: 7473
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle