Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
PL/SQL Release 126.96.36.199.0 - Production
CORE 188.8.131.52.0 Production
TNS for Linux: Version 184.108.40.206.0 - Production
NLSRTL Version 220.127.116.11.0 - Production
I'm trying to run a LinqToEntities query (C#) against Oracle as follows:
_MyEF.Table1.Include("Table2").Include("Table2.Table3").Include("Table2.Table4").Include("Table2.Table4.Table5").Include("Table2.Table4.Table6").Where(a => a.Field1 == 1).Load();
For some reason, performing this kind of query against the Oracle Server is raising a System.Data.EntityCommandExecutionException with the ubiquitous inner exception "missing right parenthesis" and the even more mysterious inner inner exception "Does not support APPLY". Any idea what's going on and how I can rewrite my LinqToEntity query (without using Lazy Loading) to work with Oracle?