dotConnect Oracle Cross Apply
Posted: Tue 11 Dec 2012 13:47
Hello,
In some machines it happens, in another don“t. We get the Cross Apply exception when using this query:
public IQueryable<GE_MENU> RetornaMenusParaUsuario(int seqUsuario, int nroEmpresa)
{
return from usuarioPerm in entidadesConsinco.GE_USUARIOPERMISSAO
where usuarioPerm.SEQUSUARIO == seqUsuario && usuarioPerm.NROEMPRESA == nroEmpresa && usuarioPerm.PERMISSAO == True
from menu in usuarioPerm.GE_ITENSAPP.GE_APLICACAO.GE_MENUAPLICACAOs
select menu.GE_MENU;
}
And using this way:
var menusUsuario = RetornaMenusParaUsuario(seqUsuario, nroEmpresa).Distinct().ToList();
The point is that we can run the query in some machines and the result is OK. But and another machine we get the exception.
What can be happening?
Thanks.
In some machines it happens, in another don“t. We get the Cross Apply exception when using this query:
public IQueryable<GE_MENU> RetornaMenusParaUsuario(int seqUsuario, int nroEmpresa)
{
return from usuarioPerm in entidadesConsinco.GE_USUARIOPERMISSAO
where usuarioPerm.SEQUSUARIO == seqUsuario && usuarioPerm.NROEMPRESA == nroEmpresa && usuarioPerm.PERMISSAO == True
from menu in usuarioPerm.GE_ITENSAPP.GE_APLICACAO.GE_MENUAPLICACAOs
select menu.GE_MENU;
}
And using this way:
var menusUsuario = RetornaMenusParaUsuario(seqUsuario, nroEmpresa).Distinct().ToList();
The point is that we can run the query in some machines and the result is OK. But and another machine we get the exception.
What can be happening?
Thanks.