Hello, firs at all i don“t know english very well, take it easy
please.

I need some help to create searches that involve many tables.

I tried using LINQ, something like this:

            Dim query = (From pedido In session.Linq(Of Pedido)() _
                         Join lista In session.Linq(Of ListaDeCompras)
() _
                         Join item In session.Linq(Of ItemProduto)() _
                         Join produto In session.Linq(Of Produto)() _
                         Join revelacao In session.Linq(Of Revelacao)
() _
                         On revelacao.Id Equals produto.Id _
                         On produto.Id Equals item.Produto.Id _
                         On item.ListaDeCompras.Id Equals lista.Id _
                         On lista.Id Equals pedido.ListaDeCompras.Id _
                         Where pedido.Envio.DataEntrega < dataFinal _
                         AndAlso pedido.Envio.DataEntrega >
dataInicial _
                         AndAlso
pedido.Estado.Equals(EnumEstadoPedido.Finalizado) _
                         Select pedido).ToList

the error mensage i got is: "The method Join is not implemented."

Can anyone help me? Thx!

-- 
You received this message because you are subscribed to the Google Groups 
"NHibernate Contrib - Development Group" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/nhcdevs?hl=en.

Reply via email to