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
All,

Oracle Version Stuff:

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

Thanks in advance.

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

Legend

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