v9.5.399, ef core, bool type causes Exception ORA-00920

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
lonwern
Posts: 2
Joined: Wed 29 Nov 2017 08:22

v9.5.399, ef core, bool type causes Exception ORA-00920

Post by lonwern » Wed 29 Nov 2017 09:27

this happens on both net461 and netcoreapp2.0

code:

Code: Select all

dbContext.Users.Where(u => u.IsActive).ToList()
entity:

Code: Select all

public class User
{
    public string UserName { get; set; }
    public string Password { get; set; }
    public bool IsActive { get; set; }
}
generated sql:

Code: Select all

SELECT "u"."UserName", "u"."IsActive", "u"."Password"
FROM "Users" "u"
WHERE "u"."IsActive"

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: v9.5.399, ef core, bool type causes Exception ORA-00920

Post by Shalex » Fri 01 Dec 2017 10:07

The bug with using bool properties in the Where() clause of LINQ query in EF Core 2 is fixed. We will notify you when the corresponding public build is available.

We have sent the internal build (NuGet packages) with the fix to your email.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: v9.5.399, ef core, bool type causes Exception ORA-00920

Post by Shalex » Fri 30 Mar 2018 17:15

The bug with using bool properties in the Where() clause of LINQ query in EF Core 2 is fixed starting from v9.5.429: https://www.devart.com/dotconnect/oracl ... story.html.

Post Reply