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

Attachments

1

Activity

Show:

Alex Zaytsev May 16, 2020 at 9:13 AM

Moved here.

Benjamin Hemken March 17, 2016 at 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).

Matthias Kramp June 23, 2014 at 8:10 AM

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

Bilal Fazlani June 23, 2014 at 7:18 AM

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

Daniel Laberge June 17, 2013 at 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.

Fixed
Pinned fields
Click on the next to a field label to start pinning.
Details

Assignee

Alex Zaytsev

Reporter

Alex Baker

Components

Fix versions

Affects versions

Priority

Who's Looking?

Open Who's Looking?
Created October 13, 2010 at 1:59 PM
Updated May 16, 2020 at 9:13 AM
Resolved May 16, 2020 at 9:13 AM
Who's Looking?