I agree this is very important. There's at least one open issue regarding
it: https://nhibernate.jira.com/browse/NH-2379.
RP
On Tuesday, January 29, 2013 6:27:49 AM UTC, cremor wrote:
>
> You can do left joins over navigation properties.
> Left joins without navigation properties are also not possible in HQL. And
> since Linq is build on HQL, Linq can't support it until it is implemented
> in HQL.
>
> On Monday, January 28, 2013 5:04:36 PM UTC+1, avi taib wrote:
>>
>>
>> hi,
>> current version of nhibernate is 3.3.2, and still simple "sql left join
>> task" is immposible !
>> i think this is a major issue ,
>> we should be able to perform simple "sql left join" using linq , e.g :
>>
>> var query = from p in session.Query<Person>()
>> join pa in session.Query<PersonAddress>() on p.Id equals
>> pa.PersonId into tempAddresses
>> from addresses in tempAddresses.DefaultIfEmpty()
>> select new { p.FirstName, p.LastName, addresses.State
>> });
>>
>> thanks,
>> avi.
>>
>>
>>
--
---
You received this message because you are subscribed to the Google Groups
"nhibernate-development" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
