http://nhforge.org/doc/nh/en/index.html#collections-example
On Mon, Feb 7, 2011 at 9:34 AM, bstack <[email protected]> wrote: > All, > > I have the following entities: > > public class Parent > { > public Guid Id; > > public string Description; > > public IList<Child> Children; > } > > public class Child > { > public Guid Id; > > public Guid ParentId; > > public string Description; > } > > I have the following mappings: > > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default- > access="field"> > <class name="ClassLibrary1.Parent, ClassLibrary1" table="dbo. > [TEMP_Parent]" lazy="false" > > <id name="Id"> > <generator class="guid.comb" /> > </id> > <property name="Description" /> > <bag name="Children" cascade="all" lazy="false" > > <key column="ParentId" foreign-key="true"/> > <one-to-many class="ClassLibrary1.Child" /> > </bag> > </class> > </hibernate-mapping> > > > <?xml version="1.0" encoding="utf-8" ?> > <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2" default- > access="field"> > <class name="ClassLibrary1.Child, ClassLibrary1" table="dbo. > [TEMP_Child]" lazy="false"> > <id name="Id"> > <generator class="guid.comb" /> > </id> > <property name="ParentId" /> > <property name="Description" /> > </class> > </hibernate-mapping> > > > When I run the following test I get an error: > > [Test] > public void Test1() > { > var _parent = new Parent(); > _parent.Description = "Parent desc"; > _parent.Children = new List<Child>(); > _parent.Children.Add(new Child > { > Description = "child desc 1" > }); > _parent.Children.Add(new Child > { > Description = "child desc 2" > }); > > var _repository = new Repository(this.c_sessionManager); > _repository.Save(_parent); > } > > NHibernate: INSERT INTO dbo.[TEMP_Parent] (Description, Id) VALUES > (@p0, @p1);@p0 = 'Parent desc', @p1 = 8c7f22c3-1a86-478a- > b8a7-9e8300cdc91b > NHibernate: INSERT INTO dbo.[TEMP_Child] (ParentId, Description, Id) > VALUES (@p0, @p1, @p2);@p0 = 00000000-0000-0000-0000-000000000000, @p1 > = 'child desc 1', @p2 = db3c4259-58bb-4ca0-80e5-9e8300cdc924 > 12:29:14,711 ERROR [ 7] AbstractBatcher [(null)]- Could not execute > command: INSERT INTO dbo.[TEMP_Child] (ParentId, Description, Id) > VALUES (@p0, @p1, @p2) > System.Data.SqlClient.SqlException (0x80131904): The INSERT statement > conflicted with the FOREIGN KEY constraint "PK_TEMP_Child_ForeignKey". > The conflict occurred in database "OLCTG_v2", table "dbo.TEMP_Parent", > column 'Id'. > The statement has been terminated. > > The childs foreign key back to the parent is never populated. > Any suggestions to resolve this issue? > > Cheers, > Billy Stack > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- Fabio Maulo -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
