Nested Table LINQ Error - ORA-00904 invalid identifier

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
babu_2082
Posts: 2
Joined: Mon 07 May 2012 09:19

Nested Table LINQ Error - ORA-00904 invalid identifier

Post by babu_2082 » 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.

Pinturiccio
Devart Team
Posts: 2125
Joined: Wed 02 Nov 2011 09:44

Re: Nested Table LINQ Error - ORA-00904 invalid identifier

Post by Pinturiccio » Wed 16 May 2012 12:58

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

Post Reply