hi, thanks for your comment, i think "pushing forward" NH-2710 <https://nhibernate.jira.com/browse/NH-2710> combine with NH-2379 <https://nhibernate.jira.com/browse/NH-2379> should do the job, am i right ? On Tuesday, January 29, 2013 8:27:49 AM UTC+2, 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.
