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: 801
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