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?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
