Inner Exception:ORA-00904: "Extent1"."IsModified": invalid identifier

[anand123]

after generating codefirst using DevArt from Working EDMX model getting below error.

below columns not in actual table, POCO class and mapping configuration as well. But ef generating query looking for those columns.

Code: Select all

 "Extent1"."DisableEvent",
"Extent1"."RowNumberValue",
"Extent1"."IsNew",
"Extent1"."IsModified"
FROM USERS "Extent1"

Code: Select all

An error occurred while executing the command definition. See the inner exception for details.
Inner Exception:ORA-00904: "Extent1"."IsModified": invalid identifier

SELECT 
"Extent1".USERID,
"Extent1".FIRST_NAME,
"Extent1".LAST_NAME,
"Extent1".EMAIL_ADDRESS,
"Extent1".PHONE_NO,
"Extent1".FAX_NO,
"Extent1".ID,
"Extent1"."DisableEvent",
"Extent1"."RowNumberValue",
"Extent1"."IsNew",
"Extent1"."IsModified"
FROM USERS "Extent1"
WHERE (((UPPER("Extent1".USERID)) = :p__linq__0) OR ((UPPER("Extent1".USERID) IS NULL) AND (:p__linq__0 IS NULL))) AND ROWNUM <= 1
-- p__linq__0: 'SYSADM' (Type = String, Size = 6)
-- Executing at 3/11/2015 14:25:40 +05:30

[Shalex]

Please send us a small test project with the corresponding DDL script so that we can reproduce the issue in our environment.

[anand123]

Thanks for your comment Shalex .

It works now. actually there were some old devArt version references. after cleaning up it works now.

[MariiaI]

Glad to see that the issue was resolved.
If you have any further questions, feel free to contact us.