Devart Oracle Cross Apply Exception

Posted by Murilo Amaru Gomes on Stack Overflow See other posts from Stack Overflow or by Murilo Amaru Gomes
Published on 2012-12-11T17:01:43Z Indexed on 2012/12/11 17:03 UTC
Read the original article Hit count: 795

I´m running a problem where in one machine the code works and another don´t. Apparently we´re using the same Devart dotConnect for Oracle version (6.80.325.0). The problem is when we have a subquery in the LINQ and we get Cross Apply Not Supported for Oracle.

public IQueryable<GE_MENUAPLICACAO> RetornaMenusNegadosParaUsuario2(int seqUsuario, int nroEmpresa)
    {
        return from usuarioPerm in entidadesConsinco.GE_USUARIOPERMISSAO
               from menu in usuarioPerm.GE_ITENSAPP.GE_APLICACAO.GE_MENUAPLICACAOs
               select menu;
    }

I read a lot about it, and about subqueries, but I really can´t understand why it´s OK in some machines and not OK and another. Did I missed some fix in the installation?

Thanks.

© Stack Overflow or respective owner

Related posts about entity-framework

Related posts about devart