EF-Core: ORA-00920 error with boolean value

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
palmi
Posts: 20
Joined: Thu 16 Feb 2017 16:52

EF-Core: ORA-00920 error with boolean value

Post by palmi » Thu 16 Feb 2017 17:03

Hi Support,

I use dotConnect with EF Core.
I defined following fields in my table:

Code: Select all

[Required]
public bool IsFavorite { get; set; }
[Required]
public string CreatedBy { get; set; }
But when I execute following LINQ-Expression:

Code: Select all

_testRepository.Where(o => o.IsFavorite && o.CreatedBy == user);
I get following exception:
ORA-00920: invalid relational operator
But when I execute each queries on its own:

Code: Select all

_testRepository.Where(o => o.IsFavorite);
_testRepository.Where(o => o.CreatedBy == user);
it works fine.
What do I do wrong?

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

Re: EF-Core: ORA-00920 error with boolean value

Post by Shalex » Mon 20 Feb 2017 19:46

Thank you for your report. The bug is fixed. We will notify you when the corresponding public build of dotConnect for Oracle is available for download.

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

Re: EF-Core: ORA-00920 error with boolean value

Post by Shalex » Fri 03 Mar 2017 09:37

New build of dotConnect for Oracle 9.2.220 is available for download now: viewtopic.php?f=1&t=35058.

Post Reply