Page 1 of 1

EF-Core: ORA-00920 error with boolean value

Posted: Thu 16 Feb 2017 17:03
by palmi
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?

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

Posted: Mon 20 Feb 2017 19:46
by Shalex
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.

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

Posted: Fri 03 Mar 2017 09:37
by Shalex
New build of dotConnect for Oracle 9.2.220 is available for download now: viewtopic.php?f=1&t=35058.