Add support of Left Joins to Linq Provider

Description

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()

Environment

None

Activity

Show:
Daniel Laberge
June 17, 2013, 1:47 PM

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.

Bilal Fazlani
June 23, 2014, 7:18 AM

Is anyone looking into this ? Left join with linq is a very basic need for developers using nhibernate.

Matthias Kramp
June 23, 2014, 8:10 AM

I'm watching for this issue too. I'm afraid, that the further development of nHibernate since month runs very slow?

Benjamin Hemken
March 17, 2016, 7:17 PM
Edited

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).

Alex Zaytsev
May 16, 2020, 9:13 AM

Moved here.

Assignee

Alex Zaytsev

Reporter

Alex Baker

Labels

Components

Fix versions

Affects versions

Priority

Major
Configure