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.
