Fluent NHibernate - 如何映射到引用查找表的表

Question

我有下面定义的 4 个表：

Projects:
    Project_Id
    Project_Name
Vendors:
    Vendor_Id
    Vendor_Name
Project_Vendors:
    Project_Vendor_Id
    Project_Id
    Vendor_Id
Project_Vendor_Payments:
    Payment_Id
    Project_Vendor_Id
    Payment_Amount

我甚至不确定从哪里开始定义我的类以使用 Fluent NHibernate，更不用说定义我的映射了。

一个项目可以

有多个与之关联的供应商，一个供应商可以为每个项目接收许多付款。

关于如何实现这一目标的任何想法？

Answer 1

我通过不引用我的查找表而只是使用直接引用实体的外键列来解决此问题。

这是我的表结构：

Projects:
    Project_Id
    Project_Name
Vendors:
    Vendor_Id
    Vendor_Name
Project_Vendors:
    Project_Vendor_Id
    Project_Id
    Vendor_Id
Project_Vendor_Payments:
    Payment_Id
    Project_Id
    Vendor_Id
    Payment_Amount

我的类定义为：

public class Project
{
    public virtual int Id { get; set; }
    public virtual string Name { get; set; }
    public virtual IList<Vendor> Vendors { get; set; }
    public virtual IList<VendorPayment> VendorPayments { get; set; }
}
public class Vendor
{
    public virtual int Id { get; set; }
    public virtual string Name { get; set; }
}
public class VendorPayment
{
    public virtual int Id { get; set; }
    public virtual Vendor Vendor { get; set; }
    public virtual float Amount { get; set; }
}

还有我的映射：

public ProjectMappings : ClassMap<Project>
{
    public ProjectMappings()
    {
        Table("Projects");
        Id(x => x.Id).Column("Project_Id");
        HasManyToMany(x => x.Vendors).Table("Project_Vendors")
            .ParentKeyColumn("Project_Id")
            .ChildKeyColumn("Vendor_Id")
            .Cascade.AllDeleteOrphan();
        HasMany(x => x.VendorPayments).Table("Project_Vendor_Payments")
            .KeyColumn("Project_Id")
            .Cascade.AllDeleteOrphan();
        Map(x => x.Name).Column("Project_Name")
    }
}
public class VendorMappings : ClassMap<Vendor>
{
    public VendorMappings()
    {
        Table("Vendors");
        Id(x => x.Id).Column("Vendor_Id");
        Map(x => x.Name).Column("Vendor_Name");
    }
}
public class VendorPaymentMappings : ClassMap<VendorPayment>
{
    public VendorPaymentMappings()
    {
        Table("Project_Vendor_Payments");
        Id(x => x.Id).Column("Payment_Id");
        References(x => x.Vendor).Column("Vendor_Id");
        Map(x => x.Amount).Column("Payment_Amount");
    }
}

这不是我问题的确切答案，而只是问题的解决方案。仍在寻找如何完全按照问题中的内容进行操作。