Nhibernate Parent Child未获取子列表

本文关键字：列表 获取 Parent Child Nhibernate | 更新日期: 2023-09-27 18:30:08

我有一个对象"Location"，它有一个子位置列表。我的对象和映射看起来像这个

    private int _id;
    private string _name;
    private IList<Location> _subLocations;
    private IList<Stock> _stockList;
    private Location _parent;
    private bool _isActive;
    private bool _recommend;
    public virtual IList<Location> SubLocations
    {
        get
        {
            if (_subLocations == null)
            {
                _subLocations = new List<Location>();
            }
            return _subLocations;
        }
        set
        {
            _subLocations = value;
            OnPropertyChanged("SubLocations");
        }
    }
    // more properties ...

我的地图是这样的：

public class LocationMap:ClassMap<Location>
{
    public LocationMap()
    {
        Id(x => x.Id);
        Map(x => x.Name);
        Map(x => x.IsActive);
        References(x => x.Parent);
        HasMany(x => x.SubLocations).Where(x => x.IsActive == true);
        HasMany(x => x.StockList).Where(x => x.IsActive == true);            
        Table("tbl_locations");
    }
}

我也100%确信定位对象具有IsActive=真正的

但是当我得到一个Location对象时，SubLocations列表总是空的。有人知道这是怎么回事吗？或者有没有调试这样一个问题的想法？

编辑我的数据库如下：

   Id   Name          IsActive  Parent_id
   1    Magazijn A       1     NULL
   2    Magazijn B       1     NULL
   3    Gang A           1      2
   4    Rek B            1          3

查询这是我获取所有父位置的查询

    public IList<Location> GetAllParentLocations()
    {
        var result = NHibernateHelper.Session.CreateQuery("from Location l fetch all properties where l.Parent is null and l.IsActive = true").List<Location>();
        return (List<Location>)result ?? new List<Location>();
    }

生成的SQL

      NHibernate: select location0_.Id as Id15_, location0_.Name as Name15_,  location0_.IsActive as IsActive15_, location0_.Parent_id as Parent4_15_ from tbl_locations location0_ where (location0_.Parent_id is null) and location0_.IsActive=1
NHibernate: SELECT sublocatio0_.Location_id as Location5_1_, sublocatio0_.Id as Id1_, sublocatio0_.Id as Id15_0_, sublocatio0_.Name as Name15_0_, sublocatio0_.IsActive as IsActive15_0_, sublocatio0_.Parent_id as Parent4_15_0_ FROM tbl_locations sublocatio0_ WHERE  (sublocatio0_.IsActive = 1) and sublocatio0_.Location_id=@p0;@p0 = 1 [Type: Int32 (0)]
         NHibernate: SELECT sublocatio0_.Location_id as Location5_1_, sublocatio0_.Id as Id1_, sublocatio0_.Id as Id15_0_, sublocatio0_.Name as Name15_0_, sublocatio0_.IsActive as IsActive15_0_, sublocatio0_.Parent_id as Parent4_15_0_ FROM tbl_locations sublocatio0_ WHERE  (sublocatio0_.IsActive = 1) and sublocatio0_.Location_id=@p0;@p0 = 42 [Type: Int32 (0)]
NHibernate: SELECT sublocatio0_.Location_id as Location5_1_, sublocatio0_.Id as Id1_, sublocatio0_.Id as Id15_0_, sublocatio0_.Name as Name15_0_, sublocatio0_.IsActive as IsActive15_0_, sublocatio0_.Parent_id as Parent4_15_0_ FROM tbl_locations sublocatio0_ WHERE  (sublocatio0_.IsActive = 1) and sublocatio0_.Location_id=@p0;@p0 = 60 [Type: Int32 (0)]

在查询中，它在"Location_id"列上执行where子句。但是它必须使用Parent_id列。不确定此Location_id列的来源。。。

Nhibernate Parent Child未获取子列表

您关闭了延迟加载吗？我建议你看看这个关于懒惰加载的链接nHibernate需要懒惰加载吗？

以下链接解决了我的问题：

Fluent NHibernate HasMany外键映射问题

我已将映射更改为：

HasMany(x => x.SubLocations).KeyColumns.Add("Parent_Id").Where(x => x.IsActive == true);
相关文章：