The attached sample identifies a number of issues in the LINQ provider related to the use of the "Join" expression. Specifically when performing outer joins or pre filtering the result set to be join in the join.
for example
select *
from table 1 a
left join table 2 b
on a.id = b.id
and b.start_date < getdate()
That's the master branch and that commit is just a fix for specific use case (left join with group by). This feature has been in master for over 8 months. Until it's back-ported to the 3.3.x branch it's not going to be seen in an actual release.
Is anyone looking into this ? Left join with linq is a very basic need for developers using nhibernate.
I'm watching for this issue too. I'm afraid, that the further development of nHibernate since month runs very slow?
Hi, the same here. We need the ability to use left outer joins without navigation properties. Navigation properties are in our case over the top because we're using NHibernate just as a simple mapper (with StatelessSession).
Moved here.