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

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

Postby hom_rcp » Tue 26 Jun 2012 11:52

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

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);

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

Any help?
Posts: 10
Joined: Sun 13 Feb 2011 12:06
Location: SY

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

Postby Shalex » Wed 27 Jun 2012 16:13

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
WHERE ((LOWER("Extent1".DNAME)) = :p__linq__0) AND ROWNUM <= 1

Please upgrade to 7.0.25 and notify us about the results.
Devart Team
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for Oracle