1 Reply Latest reply: Oct 5, 2012 6:50 PM by 15208 RSS

    Linq to Entities Multiple Children ODAC Right Paranthesis not Found

    932936
      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