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

    Linq to Entities Multiple Children ODAC Right Paranthesis not Found


      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