This discussion is archived
1 Reply Latest reply: Oct 5, 2012 4:50 PM by 15208 RSS

Linq to Entities Multiple Children ODAC Right Paranthesis not Found

932936 Newbie
Currently Being Moderated

Oracle Version Stuff:

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE     Production
TNS for Linux: Version - Production
NLSRTL Version - 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?

Thanks in advance.

Edited by: 929933 on Oct 5, 2012 2:23 PM


  • Correct Answers - 10 points
  • Helpful Answers - 5 points