asp.net-mvc – 从asp.net POST动作方法更新nhibernate实体的正

鉴于以下“域”类：

public class Person
{
    private IList<Pet> pets;

    protected Person()
    { }

    public Person(string name)
    {
        Name = name;
        pets = new List<Pet>();
    }

    public virtual Guid Id { get; set; }
    public virtual string Name { get; set; }
    public virtual IEnumerable<Pet> Pets
    {
        get { return pets; }
    }

    public virtual void AddPet(Pet pet)
    {
        pets.Add(pet);
    }

    public virtual void RemovePet(Pet pet)
    {
        pets.Remove(pet);
    }
}

public class Pet
{
    protected Pet()
    { }

    public Pet(string name)
    {
        Name = name;
    }

    public virtual Guid Id { get; set; }
    public virtual string Name { get; set; }
}

使用以下映射：

public class PersonMap : ClassMap<Person>
    {
        public PersonMap()
        {
            LazyLoad();
            Id(x => x.Id).GeneratedBy.GuidComb();
            Map(x => x.Name);
            HasMany(x => x.Pets)
                   .Cascade.AllDeleteOrphan()
                   .Access.AsLowerCaseField()
                   .SetAttribute("lazy","false");
        }
    }

    public class PetMap : ClassMap<Pet>
    {
        public PetMap()
        {
            Id(x => x.Id).GeneratedBy.GuidComb();
            Map(x => x.Name);
        }
    }

这个测试：

[Test]
    public void CanDeleteChildren()
    {
        Person person = new Person("joe");

        Pet dog = new Pet("dog");
        Pet cat = new Pet("cat");

        person.AddPet(dog);
        person.AddPet(cat);

        Repository.Save(person);

        UnitOfWork.Commit();

        CreateSession();
        UnitOfWork.BeginTransaction();

        Person retrievedPerson = Repository.Get<Person>(person.Id);
        Repository.Evict(retrievedPerson);

        retrievedPerson.Name = "Evicted";

        Assert.AreEqual(2,retrievedPerson.Pets.Count());
        retrievedPerson.RemovePet(retrievedPerson.Pets.First());

        Assert.AreEqual(1,retrievedPerson.Pets.Count());

        Repository.Save(retrievedPerson);

        UnitOfWork.Commit();

        CreateSession();
        UnitOfWork.BeginTransaction();

        retrievedPerson = Repository.Get<Person>(person.Id);
        Assert.AreEqual(1,retrievedPerson.Pets.Count());
    }

运行并生成以下sql：

DeletingChildrenOfEvictedObject.CanDeleteChildren：已通过
NHibernate：INSERT INTO [Person](Name,Id)VALUES(@ p0,@ p1); @ p0 =’joe’,@ p1 =’cd123fc8-6163-42a5-aeeb-9bf801013ab2′

NHibernate：INSERT INTO [Pet](Name,@ p1); @ p0 =’dog’,@ p1 =’464e59c7-74d0-4317-9c22-9bf801013abb’

NHibernate：INSERT INTO [Pet](Name,@ p1); @ p0 =’cat’,@ p1 =’010c2fd9-59c4-4e66-94fb-9bf801013abb’

NHibernate：UPDATE [Pet] SET Person_id = @ p0 WHERE Id = @ p1; @ p0 =’cd123fc8-6163-42a5-aeeb-9bf801013ab2′,@ p1 =’464e59c7-74d0-4317-9c22-9bf801013abb’

NHibernate：UPDATE [Pet] SET Person_id = @ p0 WHERE Id = @ p1; @ p0 =’cd123fc8-6163-42a5-aeeb-9bf801013ab2′,@ p1 =’010c2fd9-59c4-4e66-94fb-9bf801013abb’

NHibernate：SELECT person0_.Id as Id5_0_,person0_.Name as Name5_0_ FROM [Person] person0_ WHERE person0_.Id=@p0; @ p0 =’cd123fc8-6163-42a5-aeeb-9bf801013ab2′

NHibernate：SELECT pets0_.Person_id as Person3_1_,pets0_.Id as Id1_,pets0_.Id as Id6_0_,pets0_.Name as Name6_0_ FROM [Pet] pets0_ WHERE pets0_.Person_id=@p0; @ p0 =’cd123fc8-6163-42a5-aeeb-9bf801013ab2′

NHibernate：UPDATE [Person] SET Name = @ p0 WHERE Id = @ p1; @ p0 =’被驱逐’,@ p1 =’cd123fc8-6163-42a5-aeeb-9bf801013ab2′

NHibernate：UPDATE [Pet] SET Name = @ p0 WHERE Id = @ p1; @ p0 =’dog’,@ p1 =’464e59c7-74d0-4317-9c22-9bf801013abb’
NHibernate：UPDATE [Pet] SET Person_id = null WHERE Person_id = @ p0 AND Id = @ p1; @ p0 =’cd123fc8-6163-42a5-aeeb-9bf801013ab2′,@ p1 =’010c2fd9-59c4-4e66-94fb-9bf801013abb’

NHibernate：DELETE FROM [Pet] WHERE Id = @ p0; @ p0 =’010c2fd9-59c4-4e66-94fb-9bf801013abb’

NHibernate：SELECT person0_.Id as Id5_0_,pets0_.Name as Name6_0_ FROM [Pet] pets0_ WHERE pets0_.Person_id=@p0; @ p0 =’cd123fc8-6163-42a5-aeeb-9bf801013ab2′

注意DELETE FROM [Pet] ……

所以,你需要能够做的是手工操作一个Person对象(在这个例子中)与修改后的集合,它应该能够确定要删除的内容.确保设置了Cascade.AllDeleteOrphan()属性.