LINQ to NHibernate无法送达孩子的孩子 [英] LINQ to NHibernate can't get to children's children
问题描述
我有一个实体A,它的B的IList称为Bs,而B有一个C的IList称为Cs.
I have entity A which has an IList of B called Bs and B has an IList of C called Cs.
我要搜索其中至少有5个C的所有A.所以我去写了
I want to search for all A's which have at least 5 C's in them. So I went and wrote
using (var s = this._sessionFactory.OpenSession())
{
IQueryable<A> q = s.Linq<A>();
// some code...
if (range.Min.HasValue)
q = q.Where(a => a.Bs.Sum(b => b.Cs.Count) >= range.Min.Value);
// some code...
return q.Select(b=>b).ToArray();
}
但是,在执行代码(并在range变量中指定Min)时,出现以下异常:
However upon executing the code (and having Min specified in the range variable) I get the following exception :
NHibernate.QueryException:无法解析属性:C of:A
NHibernate.QueryException : could not resolve property: Cs of: A
为什么要在A上寻找B的属性?映射似乎是正确的:
Why does it look for the B's property on A? The mappings seem to be right though :
A上的(流利)映射说:
The (Fluent) mapping on A says :
//...
HasMany(a => a.Bs)
.Table("Bs")
.KeyColumn("IdA")
.Cascade.AllDeleteOrphan()
.Inverse()
.Not.LazyLoad();
//...
在B上的映射上说:
//...
HasMany(b => b.Cs)
.Table("Cs")
.KeyColumn("IdB")
.Cascade.AllDeleteOrphan()
.Inverse()
.Not.LazyLoad();
References(b => b.A, "IdA")
.Not.LazyLoad();
//...
最后在C上进行映射:
References(c => c.B, "IdB").Not.LazyLoad();
推荐答案
使用LINQ to NHibernate 2.x无法做到这一点
You can't do it with LINQ to NHibernate 2.x
这篇关于LINQ to NHibernate无法送达孩子的孩子的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!