Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

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

Attachments

1

Activity

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

Details

Assignee

Reporter

Labels

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?