Fluent NHibernate：没有外键的映射属性？

发布于 2024-11-09 00:21:28 字数 481 浏览 1 评论 0原文

我有这两个类：

public class Parent
{
    public virtual string Name { get; set; }
    public virtual string Family_id { get; set; }
}

public class Children
{
    public virtual string Name { get; set; }
    public virtual DateTime BirthDate { get; set; }
    public virtual string Family_id { get; set; }
}

当我获取父级时，我还想获取与父级具有相同 Family_id 的最年长（按出生日期排序）的子级。

数据库中的父级和子级之间没有外键。

（我不想使用两个不同的存储库，我想要映射中的功能）

我可以使用 property-ref 吗？

原文

I have these two classes:

public class Parent
{
    public virtual string Name { get; set; }
    public virtual string Family_id { get; set; }
}

public class Children
{
    public virtual string Name { get; set; }
    public virtual DateTime BirthDate { get; set; }
    public virtual string Family_id { get; set; }
}

When I fetch a parent, I also want to fetch the oldest (ordered by BirthDate) children that has the same Family_id as the parent.

There is no foreign key between the parent and the children in the database.

(I do not want to use two different repositories, I want the functionality in the mappings)

Is property-ref something I can use?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

弥枳 2024-11-16 00:21:28

一种策略是对 Children 集合强制急切加载，并创建另一个属性来获取最大的孩子。

Property-Ref 用于使用非主键的列连接到另一个表。

public class Parent
{
    public virtual int Id {get; set;}
    public virtual string Name { get; set; }
    public virtual string Family_id { get; set; }
    public virtual Children OldestChild {
     get {
          return Children.OrderBy(x=>x.BirthDate).FirstOrDefault();
     }}
    public virtual IList<Children> Children {get; set;}
}

public class ParentMap : ClassMap<Parent>{
    public ParentMap(){
        Id(x=>x.Id);
        Map(x=>x.Name);
        HasMany(x=>x.Children).PropertyRef("Family_id").Fetch.Join();
    }
}

另一种可能性是向父表 (OldestChild_FK) 添加一列，然后从子表中加入该行。

One strategy would be to force an Eager Load on a Children collection and create another property to get the oldest child.

Property-Ref is used to join to another table using a column which is not the primary key.

public class Parent
{
    public virtual int Id {get; set;}
    public virtual string Name { get; set; }
    public virtual string Family_id { get; set; }
    public virtual Children OldestChild {
     get {
          return Children.OrderBy(x=>x.BirthDate).FirstOrDefault();
     }}
    public virtual IList<Children> Children {get; set;}
}

public class ParentMap : ClassMap<Parent>{
    public ParentMap(){
        Id(x=>x.Id);
        Map(x=>x.Name);
        HasMany(x=>x.Children).PropertyRef("Family_id").Fetch.Join();
    }
}

Another possibility would be to add a column to the Parent table (OldestChild_FK) and then join in that row from the Children table.

回复收藏 0 原文