NHibernate QueryOver带有Or子查询
|
好吧，我输了。我有一个看起来像这样的NHibernate查询
var subQuery = QueryOver.Of<Lead>()
.Where(x => x.Client == user.Client)
.And(x => x.LeadType == leadType && x.LeadType != LeadTypeEnum.Self)
.Select(Projections.Distinct(Projections.Id()));
var query = Session.QueryOver<Lead>()
.WithSubquery.WhereProperty(x => x.Id).In(subQuery);
Where lead.id in (select Id from .......)
Where lead.id in (select id from .....)
or lead.id in (select id from .......)
Where lead.id in (select id from .....)
and lead.id in (select id from .......)
没有找到相关结果
已邀请:
1 个回复
屉杆绊
调用中。var disjunction = new Disjunction(); disjunction.Add(subQuery1); disjunction.Add(subQuery2); var query = Session.QueryOver<Lead>() .Where(disjunction);