Exception: {"ORA-00904: \"TOLOWER\": invalid identifier"}

[hom_rcp]

I'm using Oracle - Devart Entity Model version 6.10.103.0. Working with an Oracle engine version 10.2.0.4.

The following code gives a strange exception:

Code: Select all

using (var entitie = new Gw7Model.Gw7Entities())
{
    string username = "mohd";
    var user = entitie.Employees.FirstOrDefault(p => p.Name.ToLower() == username);
}

Exception:
An error occurred while executing the command definition. See the inner exception for details.
Inner Exception:
{"ORA-00904: \"TOLOWER\": invalid identifier"}

Any help?

[Shalex]

The latest (7.0.25) version of dotConnect for Oracle works correctly, and the generated SQL (see in dbMonitor) is like the following:

Code: Select all

SELECT 
"Extent1".DEPTNO,
"Extent1".DNAME,
"Extent1".LOC
FROM SCOTT.DEPT "Extent1"
WHERE ((LOWER("Extent1".DNAME)) = :p__linq__0) AND ROWNUM <= 1

Please upgrade to 7.0.25 and notify us about the results.