2 Replies Latest reply: Aug 15, 2014 12:29 PM by Alex.Keh .Product.Manager-Oracle RSS

    2 more Any() by EF5 error

    2719208

      If use 2 more Any() in Linq by EF5 for Oracle 12c. The error is happened.

      e.g.

       

      var bor = et.VR_BORROWER.Any (f => f.VR_INCOME.Any(i => i.VR_PROPERTY.Any (p => p.PROPERTY_ID == 1324)))

       

      --------------------------------------------------------

      "System.Data.EntityCommandExecutionException: An error occurred while executing the command definition. See the inner exception for details. ---> Oracle.DataAccess.Client.OracleException: ORA-00904: \"Extent1\".\"BORROWER_ID\": invalid identifier\r\n   at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable)\r\n   at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, String procedure, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, Boolean bCheck)\r\n   at Oracle.DataAccess.Client.OracleCommand.ExecuteReader(Boolean requery, Boolean fillRequest, CommandBehavior behavior)\r\n   at Oracle.DataAccess.Client.OracleCommand.ExecuteDbDataReader(CommandBehavior behavior)\r\n   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)\r\n   at System.Data.EntityClient.EntityCommandDefinition.ExecuteSt

      oreCommands(EntityCommand entityCommand, CommandBehavior behavior)\r\n   --- End of inner exception stack trace ---\r\n   at System.Data.EntityClient.EntityCommandDefinition.ExecuteStoreCommands(EntityCommand entityCommand, CommandBehavior behavior)\r\n   at System.Data.Objects.Internal.ObjectQueryExecutionPlan.Execute[TResultType](ObjectContext context, ObjectParameterCollection parameterValues)\r\n   at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption)\r\n   at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator()\r\n   at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source)\r\n   at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__3[TResult](IEnumerable`1 sequence)\r\n   at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query, Expression queryRoot)\r\n   at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression)\r\n   at System.Data.En

      tity.Internal.Linq.DbQueryProvider.Execute[TResult](Expression expression)\r\n   at System.Linq.Queryable.Any[TSource](IQueryable`1 source, Expression`1 predicate)\r\n   at EFOracle.Program.Main(String[] args) in c:\\Users\\josh\\EFOracle\\EFOracle\\Program.cs:line 18"

      -------------------------------------------------------------------------------------------------------