Nested Table LINQ Error - ORA-00904 invalid identifier
Posted: Mon 07 May 2012 10:18
I face an issue while implementing Entity framework using Oracle.
This issue happens when we try to use nested query like below.
My LINQ expression will be like this.
List<Request> lstUP = pm.GetObjectByGraphCriteria<Request>(v => v.RequestLevel.Any(x => x.RequestApprovers.Any(y => y.ApproverCode == "")), "RequestLevel.RequestApprovers");
Error
{"ORA-00904: \"Project1\".\"C1\": invalid identifier"}
So how can i rewrite the above expressions or is there any other alternative way to do this ?
Thanks in advance.
This issue happens when we try to use nested query like below.
My LINQ expression will be like this.
List<Request> lstUP = pm.GetObjectByGraphCriteria<Request>(v => v.RequestLevel.Any(x => x.RequestApprovers.Any(y => y.ApproverCode == "")), "RequestLevel.RequestApprovers");
Error
{"ORA-00904: \"Project1\".\"C1\": invalid identifier"}
So how can i rewrite the above expressions or is there any other alternative way to do this ?
Thanks in advance.