在NHibernate上使用QueryOver来获取有限制的子项计数
||
如何使用QueryOver和无公式字段执行以下操作。
我有以下父母/子女关系
public class Club {
public string Name {get; set;}
public IList<Membership> Memberships {get; set;}
}
public class Membership {
public boolean Cancelled {get; set;}
public Club Club {get; set;}
}
IEnumerable<ClubIndexViewModelLineSummary> results = _querySession.QueryOver<Club>()
.OrderBy(c => c.IsActive).Desc
.OrderBy(c => c.Name).Asc
.SelectList(list => list
.Select(c => c.Id).WithAlias(() => sum.Id)
.Select(c => c.Name).WithAlias(() => sum.Name)
.Select(c => c.IsActive).WithAlias(() => sum.IsActive)
.Select(c => c.NumberOfWeeks).WithAlias(() => sum.NumberOfWeeks))
.TransformUsing(Transformers.AliasToBean<ClubIndexViewModelLineSummary>())
.Skip(start)
.Take(15)
.Future<ClubIndexViewModelLineSummary>();
没有找到相关结果
已邀请:
1 个回复
响摔衅幸
Club clubAlias = null; IEnumerable<ClubIndexViewModelLineSummary> results = _querySession.QueryOver<Club>(() => clubAlias) .OrderBy(c => c.IsActive).Desc .OrderBy(c => c.Name).Asc .SelectList(list => list .Select(c => c.Id).WithAlias(() => sum.Id) .Select(c => c.Name).WithAlias(() => sum.Name) .Select(c => c.IsActive).WithAlias(() => sum.IsActive) .Select(c => c.NumberOfWeeks).WithAlias(() => sum.NumberOfWeeks) .SelectSubQuery ( QueryOver.Of<ClubMembership>() .Where(c => c.Canceled == false) .And(c=> c.Club.Id == clubAlias.Id) .ToRowCountQuery() ).WithAlias(()=> sum.ActiveMembers)) .TransformUsing(Transformers.AliasToBean<ClubIndexViewModelLineSummary>()) .Skip(start) .Take(15) .Future<ClubIndexViewModelLineSummary>();