[Firebird-net-provider] The provider is creating incompatible code to Firebird

2012-01-07 Thread Marco Aurelio Castro
Hi, I find a situation that Firebird's generated code don't run because the CROSS APPLY is used. The issue is generated because I need to create a query inside the where clause. I'll show the code that runs and part of the code that brings the issue, ITENS_ENTRADA.**Where(w => (w.PRODUTOS.**ESTOQ

[Firebird-net-provider] A sugestion that can be helpfull

2012-01-07 Thread Marco Aurelio Castro
Hello, I'm starting to work with real databases, I mean, in real world. I found a problema that limits the size of the queries. The size of a query is at most 64K byes size. In an e-mail with Dimitry he sayd that is an API limitation and it won't be fixed so far. Get a query greater than 64K is v

[Firebird-net-provider] Another case of wrong generated code to Firebird

2012-01-07 Thread Marco Aurelio Castro
Hi, Continuing what I've posted in another e-mail, the following code generates now an OUTER APPLY code that is not interpreted with Firebird. var r = from cc in ConnModelos.**Context()**.CONTA_CORRENTE from ie in cc.NOTAS_ENTRADA.**ITENS_ENTRADA where Compras.Where(**c => c == cc.OPERACOES.**ALT