Nested Table LINQ Error - ORA-00904 invalid identifier

[babu_2082]

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.

[Pinturiccio]

We have answered you at our forum http://forums.devart.com/viewtopic.php?t=22349