nHibernate Linq join support; The method Join is not implemented

Question

I am using the latest nHibernate.Linq 2.1.2. But if I use join in my linq query I will get run time error "The method Join is not implemented".

Could someone tell me if join is supported by nHibernate.Linq and if it is supported what is the cause of this error?

Answer 1

Doesn't look like Joins are supported in the current version of Linq to Hibernate.

See post from Adam Aldrich's Blog here

I worked around it using two linq quiries within my session. The first one selected from the one table and the second from the second table using the values of the first result to constrain my query. Not as efficient as a Join, but since the data I was using was minimal, it worked fine.

You could also try using the Criteria API or HQL.