JoinQueryOver中的NHibernate QueryOver总和
|
尽管我正在阅读NHibernate Cookbook和所有可用的论坛帖子，但我仍然无法完成以下简单查询：
我有用户，每个人都有一个帐户。每个账户都有余额。
这些类如下所示：
public class User
{
public virtual int Id { get; set; }
public virtual Account Account { get; set; }
public virtual bool Active { get; set; }
}
public class Account
{
public virtual int Id { get; set; }
public virtual double Balance { get; set; }
}
SELECT SUM(a.Balance)
FROM User u
INNER JOIN Account a
ON u.Account_id = a.Id
WHERE u.Active = \'true\'
var result = Session.Query<User>()
.Where(x => x.Active)
.Sum(x => x.Account.Balance)
User userAlias = null;
Account accountAlias = null;
session.QueryOver<User>(() => userAlias)
.JoinAlias(() => userAlias.Account, () => accountAlias)
.Where(() => userAlias.Active)
.Select(Projections.Sum<Account>(acct => accountAlias.Balance))
.SingleOrDefault<double>()
没有找到相关结果
已邀请:
2 个回复
杰黔轿缺
session.QueryOver<User>(() => userAlias) .JoinAlias(() => userAlias.Account, () => accountAlias) .Where(() => userAlias.Active) .Select(Projections.Sum<Account>(acct => acct.Balance)) .UnderlyingCriteria.UniqueResult()悸翠疮武昏
User userAlias = null; Account accountAlias = null; session.QueryOver<User>(() => userAlias) .JoinAlias(() => userAlias.Account, () => accountAlias) .Where(() => userAlias.Active) .Select(Projections.Sum<Account>(acct => accountAlias.Balance)) .SingleOrDefault<double>()Account accountAlias = null; session.QueryOver<User>() .JoinAlias(user => user.Account, () => accountAlias) .Where(user => user.Active) .Select(Projections.Sum<Account>(acct => accountAlias.Balance)) .SingleOrDefault<double>()