This content has been marked as final. Show 3 replies
Out of curiousity, have you tried tossing the output SQL into SQL Developer and running it direcctly against the database? What errors is that throwing up?
There are some types of queries that Oracle can do that can't really be done in EF currently (Spatial stuff and CONNECT BY PRIOR are typical examples). In those cases I either run the SQL directly or use a stored procedure and call that, depending on the situation. This query may be one of those. In this case though you might be able to rewrite the EF query a different way, but without the schema I'm really not sure what that query is trying to do so don't have much advice there.
ORA-00904: "Extent1"."FieldID": invalid identifier
Extent1, Extent2, Extent3, Extent4 and Project1 are all alias' created by EF. None of them are actually tables in the scheme. They are each defined in the query.
Regarding this error Devart says
Please refer to http://www.devart.com/dotconnect/oracle/faq.html#q56. We recommend you to reconstruct your EF query to avoid the situation when a column from the outer query is used in the subquery of level 2 and deeper. EF query should be customised/modified for every particular case when someone encounters this limitation of Oracle server: http://forums.devart.com/viewtopic.php?t=22349.