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 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?
hom_rcp
 
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
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.
Shalex
Devart Team
 
Posts: 7401
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle