NHibernate.QueryException ActiveRecord

Question

   [ActiveRecord]   
    public class Category
   {
    private int _id;
    private string _name;
    private Category _category;

    [PrimaryKey(PrimaryKeyType.HiLo, "id", Params = "max_lo=9")]
    public long Id
    {
        get { return _id; }
        protected internal set { _id = value; }
    }
    [Property]
    public string Name
    {
        get { return _name; }
        set { _name = value; }
    }
    [BelongsTo("ParentCategoryId")]
    public Category ParentCategory
    {
        get { return _category;}
        set { _category = value; }
    }       
}

表在数据库中正确生成，并且可以毫无问题地插入数据

但是当我运行时

        var criteria = DetachedCriteria.For<Category>
            .Add(Restrictions.Eq("ParentCategory.ParentCategoryId", testCategory.id));           
        Assert.That(m_repository.FindAll(criteria).Length, Is.EqualTo(1));

我收到 QueryException

`NHibernate.QueryException：无法 解析属性： ParentCategory.ParentCategoryId'

有什么想法吗？

Answer 1

您正在获取类别的 ParentCategory 属性，该属性本身就是一个类别。您的 DetachedCriteria 应该是：

   var criteria = DetachedCriteria.For<Category>()
                                  .Add(Restrictions.Eq("ParentCategory.Id",
                                                       testCategory.id));