NHibernate，一列两种含义，正/负

发布于 2024-09-26 23:47:42 字数 532 浏览 3 评论 0原文

我们有一个大型管理应用程序，我们对每个操作进行大量日志记录，例如，谁在什么时间做了什么。

然而，我们拥有越来越多的自动化系统，我们也希望将它们区分开来。

在我们所有的表中，我们都有一个名为 PerformedBy 的列，它是一个 int。这始终是对名为“Employees”的表的引用，该表有一个相应的名称。

然而我们现在希望有一些系统用户（例如在线支付服务器、在线预订等）。我们当然可以在员工表中创建这些，但这似乎不正确，而且我们无法确定 ID（这是一个商业系统，因此我们有 200 个数据库需要更新。）

所以我真正想要的是要做的就是进行映射，以便如果 ID 为正，则它会映射到从数据库加载的员工。但是，如果它是否定的，我希望为每种类型的系统用户提供一些从 Employee one 派生的静态类。

比如：

class OnlineBooking : Employee
{
}

NHibernate 可以实现类似的功能吗？或者有人有另一个很好的解决方案吗？我不想向所有具有日志的表添加额外的列。

原文

We have a large management application and we do a lot of logging for every action, for instance, who did what and at what time.

However we have more and more automatic systems which we would like to differentiate as well.

In all of our tables we have a column called PerformedBy which is an int. This has always been a reference to a Table called Employees which then have a corresponding Name.

However we would now like to have some system users (for instance online payment server, online booking and so on).
We could of cause create these in the employees table however that seems incorrect and we wouldn't be certain of IDs (this is a commercial system, so we have 200 databases which would have to be updated.)

So what I would really like to do is make a mapping so that if an ID is positive it maps to an employee which is loaded from the database. However, if it is negative I would like to have some static classes which derive from Employee one for each type of system user.

Something like:

class OnlineBooking : Employee
{
}

Is something like this possible with NHibernate or does someone have another great solution ?
I would like not to add additional columns to ALL the tables that have logs.

分享到QQ

分享到微博