Geek asks and answers

Free NHibernate HasMany Does Not Insert Parent Identifier

I cannot understand why NHibernate inserts a child without a foreign key. Here are my classes

public class Order {
    public Order() {
        this.Notes = new List<OrderNote>();
    }

    public virtual int OrderId {get; private set;}
    public virtual IList<OrderNote> Notes {get; private set;}
}

public class OrderNote {
    public OrderNote(string noteBy, string note) {
        this.OrderNoteId = Guid.NewGuid();
        this.NoteBy = noteBy;
        this.Note = note;
    }

    public virtual Guid OrderNoteId {get; private set;}
    public virtual string NoteBy {get; private set;}
    public virtual string Note {get; private set;
}

Here are my Fluent NHibernate mapping files

public class OrderClassMap : ClassMap<Order> {
    public OrderClassMap() {
        Id(x => x.OrderId).GeneratedBy.Native();
        HasMany(x => x.Notes).Inverse.KeyColumn("OrderId").Cascase.AllDeleteOrphan();
    }
}

public class OrderNoteClassMap : ClassMap<OrderNote> {
    public OrderNoteClassMap() {
        Id(x => x.OrderNoteId).GeneratedBy.Assigned();
        Map(x => x.NoteBy);
        Map(x => x.Note);
    }
}

When I add a note to the collection of order notes and save the order, the order note is inserted into the database without a foreign key.

Order order = session.Query<Order>().Where(o => (o.OrderId == orderId)).Single();
order.Notes.Add(new OrderNote("Name", "This is a note"));
session.SaveOrUpdate(order);

The insert statement that is generated is as follows:

INSERT INTO OrderNotes(OrderNoteId, NoteBy, Note)

It should be:

INSERT INTO OrderNotes(OrderNoteId, NoteBy, Note, OrderId)

Why is this happening? What am I doing wrong?

+3
source share
2 answers

Add a property Orderto the class OrderNoteand set it for the order object to which you are adding a note.

Also add References(x => x.Order);to yourOrderNoteClassMap

Inverse HasMany, , .

+3

OrderNote Order OrderNote.

addNote

Order order = session.Query<Order>().Where(o => (o.OrderId == orderId)).Single();
order.AddNote(new OrderNote("Name", "This is a note"));
session.SaveOrUpdate(order);

public virtual AddNote(OrderNote note)
{
note.Order=this;
order.Notes.Add(note);
}
0

More articles:


All Articles