nhibernate儿童系列

所以让我们从代码本身开始：

public class Site
{
    private Int32 id;        
    private string name;
    private IList<SiteDomain> sitedomains;
    public Site()
    {
    }
    public virtual Int32 Id
    {
        get { return id; }
        set { id = value; }
    }
    public virtual IList<SiteDomain> Domains
    {
        get { return sitedomains; }
        set { sitedomains = value; }
    }
    public virtual string Name
    {
        get { return name; }
        set { name = value; }
    }
}
public class SiteDomain
{
    private Int32 id;
    private string domain;
    public SiteDomain()
    {
    }
    public virtual Int32 Id
    {
        get { return id; }
        set { id = value; }
    }
    public virtual string Domain
    {
        get { return domain; }
        set { domain = value; }
    }
}

所以，正如你所看到的，我不需要任何从SiteDomain到网站的链接。但我想在网站实体中有一个网站域的列表。

这是DDL：

CREATE TABLE `site` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(500) NOT NULL,
    PRIMARY KEY (`id`)
)
ENGINE=InnoDB;

CREATE TABLE `sitedomains` (
    `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `siteid` BIGINT(20) UNSIGNED NOT NULL,
    `domain` VARCHAR(500) NOT NULL,
    PRIMARY KEY (`id`),
    INDEX `sitedomains_siteid` (`siteid`),
    CONSTRAINT `FK_sitedomains_siteid` FOREIGN KEY (`siteid`) REFERENCES `site` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
)
ENGINE=InnoDB;

我现在得到的映射：

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="PhoneTracking.Core" assembly="PhoneTracking.Core">
  <class name="Site" table="site">
    <id name="Id" type="Int32">
      <column name="ID" not-null="true" />
    </id>
    <property name="Name" type="AnsiString" />
    <list name="Domains" cascade="all">
      <key column="SiteId" />
      <index />
      <one-to-many class="SiteDomain" />
    </list>
  </class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="PhoneTracking.Core" assembly="PhoneTracking.Core">
  <class name="SiteDomain" table="sitedomains">
    <id name="Id" type="Int32">
      <column name="ID" not-null="true" />
    </id>
    <property name="Domain" type="AnsiString" />
  </class>
</hibernate-mapping>

当我得到一个网站时，它检索得很好。它附带了所有相关网站的域。但后来我把新网站保存回数据库，它只保存网站本身，而不插入网站的域。

我该如何改正？

我知道NHibernate的ISet。我只是想让它IList，因为它对我来说更舒适。

编辑：

<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="PhoneTracking.Core" assembly="PhoneTracking.Core">
  <class name="SiteDomain" table="sitedomains">
    <id name="Id" type="Int32">
      <column name="ID" not-null="true" />
    </id>
    <property name="Domain" type="AnsiString" />
    <many-to-one name="Site" column="siteid" />
  </class>
</hibernate-mapping>
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" namespace="PhoneTracking.Core" assembly="PhoneTracking.Core">
  <class name="Site" table="site">
    <id name="Id" type="Int32">
      <column name="ID" not-null="true" />
    </id>
    <property name="Name" type="AnsiString" />
    <bag name="Domains" inverse="true" cascade="all">
      <key column="SiteId" />
      <one-to-many class="SiteDomain" />
    </bag>
  </class>
</hibernate-mapping>

更新的SiteDomain类：

public class SiteDomain
{
    private Int32 id;
    private string domain;
    private Site site;
    public SiteDomain()
    {
    }
    public virtual Int32 Id
    {
        get { return id; }
        set { id = value; }
    }
    public virtual Site Site
    {
        get { return site; }
        set { site = value; }
    }
    public virtual string Domain
    {
        get { return domain; }
        set { domain = value; }
    }
}

以下是我如何保存动态创建的新条目：

ITransaction tx = session.BeginTransaction();
Site s = new Site();
s.Name = StringGenerator.RandomString(20) + " site";
s.Domains = new List<SiteDomain>();
s.Domains.Add(new SiteDomain { Site = s, Domain = StringGenerator.RandomString(20) + ".com" });   
session.SaveOrUpdate(s);                
tx.Commit();       

现在我得到了一个例外：

｛"无法插入：[Project.Core.SiteDomain#0][SQL:insert INTOsitedomains(Domain，siteid，ID(VALUES(？，？，？(]"｝：｛"无法添加或更新子行：外键约束失败(project.sitedomains，约束FK_sitedomains_siteid外部密钥(siteid(在更新时的删除级联中引用site(id(级联("｝