Fluent-Nhibernate 多对多关系问题

Question

我在尝试使用 Fluent Nhibernate 删除多对多关系时遇到问题。我有以下域类：

public class Organisation
{
   public virtual int Id {get; set;}

   private IList<OrganisationRelationshiop> relatedOrganisations; 

   public virtual IList<OrganisationRelationship> RelatedOrganisation
   {
       get
       {
           return this.relatedOrganisations;
       }

      protected set
      {
           this.relatedOrganisations = value;
      }
    }


    public virtual void RemoveRelatedOrganisation(OrganisationRelationship organisationRelationship)
    {
        this.relatedOrganisations.Remove(organisationRelationship);
    }

}

这是我的 OrganizationRelationship 类，它代表组织之间的多对多关系。

   public class OrganisationRelationship 
   {
       public virtual int Id {get; set;}

       public virtual Organisation Organisation{ get; set; }

       public virtual OrganisationRelationshipType OrganisationRelationshipType { get; set; }

       public virtual Organisation RelatedOrganisation { get; set; }
   }

她是表的脚本：

组织表：组织

CREATE TABLE [dbo].[Organisation](
[Id] [int] IDENTITY(1,1) NOT NULL,
[OrganisationName] [nvarchar](200) NOT NULL,
CONSTRAINT [PK_Organisation] PRIMARY KEY CLUSTERED 
(
[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,    ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

关系商店表：

CREATE TABLE [dbo].[OrganisationRelationship](
[Id] [int] IDENTITY(1,1) NOT NULL,
[OrganisationId] [int] NOT NULL,
[RelatedOrganisationId] [int] NOT NULL,
[OrganisationRelationshipTypeId] [int] NOT NULL,
CONSTRAINT [PK_OrganisationRelationship] PRIMARY KEY CLUSTERED 
(
[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,        ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

组织关系类型表：

CREATE TABLE [dbo].[OrganisationRelationshipType](
[Id] [int] IDENTITY(1,1) NOT NULL,
[Name] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_OrganisationRelationshipType] PRIMARY KEY CLUSTERED 
(
[Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF,    ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

一切都按我的预期工作，但是当我尝试删除关系时，流畅的 Nhibernate 会尝试将该特定记录的 CompanyId 设置为 null，而不是从中删除记录公司关系表。以下是我在 NHProf 中可以看到的查询：

UPDATE CompanyRelationship
SET    CompanyId = null
WHERE  CompanyId = 3893 /* @p0 */
AND Id = 487 /* @p1 */

要删除记录，我调用 RemoveRelatedCompany 函数，该函数从 relatedCompanies 列表中删除特定的 CompanyRelationship，然后调用 Session.Save() 和 Session.Flush() 来保存 Company 实体。

对于我在这里做错了什么有什么想法吗？

Answer 1

当我使用 AutoMapping 时，我必须按如下方式覆盖组织的映射才能解决问题：

mapping.HasMany(c => c.RelatedOrganizes).Inverse().ForeignKeyCascadeOnDelete().Table("OrganizationRelationship");

Answer 2

也许你必须设置 .Cascade.AllDeleteOrphan(); (cascade=“all-delete-orphan”) 在你的映射上。

另外，如果您发布您的映射将更容易回答您