criteria.CreateAlias("SomeProperty","sp", JoinType.LeftOuterJoin).Add
(Restriction.Or(....))
On Nov 20, 1:10 pm, Joao <[EMAIL PROTECTED]> wrote:
> I'm not using HQL, I'm using Criteria.
>
> Here goes a brief part of my code:
>
> var _crit = Session.CreateCriteria(persitentType);
> _crit.Add(Expression.Or(_junctionList[0], _junctionList[1]));
> // the criteria results in something like this
> [NHibernate.Impl.CriteriaImpl] = {((X is null and Y.ID = 1) or (X.ID =
> 2 and Y is null))}
> return _crit.List<T>();
>
> On 19 nov, 17:53, Joao <[EMAIL PROTECTED]> wrote:
>
>
>
> > NHibernate is generating a sql with INNER JOIN, but actually it will
> > only get the correct data if it uses LEFT OUTER JOIN.
>
> > Is there a way to set the JOIN statement that NHibernate will use?- Hide
> > quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
