nHibernate QueryOver<T>并发症
nHibernate QueryOver<T>并发症
提问于 2013-07-19 00:21:53
我有以下表格：
Customer => CustomerAccount =>帐户
我也有一个映射到上面每个表的nHibernate POCO。
我在一个实现IIdentifier<T>的对象中有以下lambda表达式
public Expression<Func<ICustomer, bool>> Filter
{
get { return customer => customer.CustomerNumber == _customerNumber; }
}现在，我要尝试通过QueryOver<Account>连接Customer => CustomerAccount =>帐户表
如何添加上述Filter lamdba，其类型为Customer，以按客户编号进行过滤？
ICustomer customer = null;
ICustomerAccount customerAccount = null;
IAccount account = null;
var query = QueryOver(() => account)
.JoinAlias(() => account.CustomerAccounts, () => customerAccount, JoinType.InnerJoin)
.JoinAlias(() => customerAccount.Customer, () => customer, JoinType.InnerJoin)
.Where(() => customerAccount.EndDate == null)
.And(() => account.IsPreferredAccount == true)
.And(() => ?? Want to add the above Filter() lambda some how here);谢谢,
凯尔
回答 1
Stack Overflow用户
发布于 2013-07-20 02:26:55
您可以尝试：
var query = QueryOver(() => account)
.JoinAlias(() => account.CustomerAccounts, () => customerAccount, JoinType.InnerJoin)
.JoinAlias(() => customerAccount.Customer, () => customer, JoinType.InnerJoin)
.Where(() => customerAccount.EndDate == null)
.And(() => account.IsPreferredAccount == true)
.And(Restrictions.Where<ICustomer>(Filter));页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/17728956
复制相关文章
相似问题
腾讯云开发者
