Code: Select all
int i = context.Query(string.Format("select count(*) from USER_SYS_PRIVS where privilege = '{0}'", privilegeName)).FirstOrDefault();
Devart.Data.Linq.LinqCommandExecutionException: Error on executing DbCommand. ---> Devart.Data.Oracle.OracleException: ORA-00904: "T2"."c1": invalid identifier
Generated query:
Code: Select all
SELECT t1."c1"
FROM (
SELECT t2."c1", ROWNUM AS "rnum"
FROM (
select count(*) from USER_SYS_PRIVS where privilege = 'CHANGE NOTIFICATION'
) t2
) t1
WHERE t1."rnum" <= 1