如何在 Fluent Nhibernate 中使用组件

发布于 2024-10-30 13:45:00 字数 562 浏览 1 评论 0原文

我正在开发一个旧版 MySql 数据库，并拥有以下实体：

public class Company
{
     public int Id { get; set;}
     public string Address { get; set; }
     public string City { get; set; }
}

public class CompanyDepartment
{
     public int Id { get; set;}
     public string Address { get; set; }
     public string City { get; set; }
}

这个想法是，一家公司仅在拥有多个部门时才使用部门类。

现在我正在尝试进行公司/部门搜索，这意味着我需要一份所有部门的列表，因此我需要“创建”所有只有一个部门的公司的部门，因此没有条目在公司部门。

为此，我正在考虑使用流畅的 NHibernate 中的组件，但我不确定我是否可以将真实的部门与假的部门结合起来？

有没有更好的方法来解决这个问题？这不是更改数据库结构的选项。

原文

I'm working on a legacy MySql database and have the following entities:

public class Company
{
     public int Id { get; set;}
     public string Address { get; set; }
     public string City { get; set; }
}

public class CompanyDepartment
{
     public int Id { get; set;}
     public string Address { get; set; }
     public string City { get; set; }
}

The idea is that a company only use the department class if it has more than one department.

Right now I'm trying to make a company/department search, this means I need a list of all departments and therefore I need to "create" departments of all the companies that only has one department, and therefore don't have a entry in CompaynyDepartment.

To do this I was thinking of use components in fluent NHibernate, but I'm not sure I can join the real departments with the fake ones?

Is there a better approach to this problem? It's not an option to change the database structure.

分享到QQ

分享到微博