使用NHibernate ICriteria / QueryOver查询向外连接添加条件 [英] Adding conditions to outer joins with NHibernate ICriteria/QueryOver query

问题描述

在外连接表上需要一些额外的条件

，但NHibernate总是把它们添加到WHERE子句的最后 - 它没有得到正确的行为（参见 http://weblogs.sqlteam.com/jeffs/archive/2007/05/14/criteria-on-outer-joined-tables.aspx ）。

使用Criteria或QueryOver语法我找不到任何方法>谢谢

解决方案

（回答我自己的问题 - 对不起！）

Fabio在NHibernate列表中回答了一个类似的查询 - 只是觉得我会在这里发布。

自NH3.0以来，Criteria可能会这样做。
HQL
中的功能 http ：//fabiomaulo.blogspot.com/2009/05/nhibernate-210-hql-with-clause.html

用Criteria看看
CreateAlias（字符串关联路径，字符串别名，JoinType连接类型，ICriterion withClause）
CreateCriteria（字符串关联路径，字符串别名，JoinType连接类型，ICriterion withClause）

使用QueryOver它不可用，但是这里有一个JIRA： https://nhibernate.jira.com /浏览/ NH-2592

Is there a way to specify additional conditions on outer joins in NHibernate when querying using QueryOver or ICriteria?

I need some extra conditions on the outer join-ed table, but NHibernate always adds them to the WHERE clause at the end - which does not get the correct behaviour (see http://weblogs.sqlteam.com/jeffs/archive/2007/05/14/criteria-on-outer-joined-tables.aspx).

I can't seem to find any way to do this using Criteria or the QueryOver syntax...

Thanks

解决方案

(Answered my own question - sorry!)

Fabio answered a similar query on the NHibernate list - just thought I'd post it here.

That is possible with Criteria since NH3.0. The feature in HQL http://fabiomaulo.blogspot.com/2009/05/nhibernate-210-hql-with-clause.html

With Criteria have a look to CreateAlias(string associationPath, string alias, JoinType joinType, ICriterion withClause) CreateCriteria(string associationPath, string alias, JoinType joinType, ICriterion withClause)

With QueryOver it is not available but there's a JIRA for this here: https://nhibernate.jira.com/browse/NH-2592

这篇关于使用NHibernate ICriteria / QueryOver查询向外连接添加条件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！