Ayende @ Rahien

Ayende Rahien commented on NHibernate Mapping -

Tue, 28 Apr 2009 04:33:18 GMT

Stevey, Take a look at constrained="true"

stevey commented on NHibernate Mapping -

Mon, 27 Apr 2009 21:13:57 GMT

I have problem about this on Eager Load. my mapping file: > > I have one person and one employee in my DB and I run this simple test: var person = repository.FindByID(new Guid ( "30ad691d-84c0-4175-815f-9bf800f86766")); Assert.That(person,Is.Not.Null); Assert.That(person.Employee, Is.Not.Null); It generate 2 sql statements: NHibernate: SELECT person0_.ID as ID4_1_, person0_.Name as Name4_1_, employee1_.ID as ID3_0_, employee1_.Name as Name3_0_, employee1_.PeopleID as PeopleID3_0_ FROM People person0_ left outer join Employees employee1_ on person0_.ID=employee1_.PeopleID WHERE person0_.ID=@p0; @p0 = '30ad691d-84c0-4175-815f-9bf800f86766' NHibernate: SELECT employee0_.ID as ID3_0_, employee0_.Name as Name3_0_, employee0_.PeopleID as PeopleID3_0_ FROM Employees employee0_ WHERE employee0_.PeopleID=@p0; @p0 = '30ad691d-84c0-4175-815f-9bf800f86766' Which I assume it should only generate one. Can I make it only generate one?

Ayende Rahien commented on NHibernate Mapping -

Thu, 23 Apr 2009 18:05:02 GMT

Take a look at the "any" post

Luiz Sergio commented on NHibernate Mapping -

Thu, 23 Apr 2009 18:03:17 GMT

How can I to create a mapping when a Person can be Employee and/or Customer and/or Author?

Nik commented on NHibernate Mapping -

Wed, 22 Apr 2009 16:18:51 GMT

In your sample Person.Id, Employee.Id and Employee.Person equals, it's not real case, this what i want to say.

Nik commented on NHibernate Mapping -

Wed, 22 Apr 2009 16:15:14 GMT

In your sample Person.Id, Employee.Id and Employee.Person, it's not real case, this what i want to say.

Ayende Rahien commented on NHibernate Mapping -

Wed, 22 Apr 2009 14:51:57 GMT

Nik, You set it up in such a way that the Id or Person and the Employee must have the same value. That is what foreign means.

Nik commented on NHibernate Mapping -

Wed, 22 Apr 2009 11:06:53 GMT

£class name="Person" table="People"£ £id name="Id"£ £generator class="foreign"£ £param name="property"£ Employee £/param£ £/generator£ £/id£ £property name="Name" /£ £one-to-one name="Employee" class="Employee" constrained="true"/£ £/class£

Nik commented on NHibernate Mapping -

Wed, 22 Apr 2009 11:04:30 GMT

In database person with id=8, employee with id=3(and in person column 8). Code: using (var session = sessionFactory.OpenSession()) using (var tx = session.BeginTransaction()) { var employee = session.Get

Ayende Rahien commented on NHibernate Mapping -

Wed, 22 Apr 2009 05:27:49 GMT

Nik, what is the error you are getting?

Nik commented on NHibernate Mapping -

Tue, 21 Apr 2009 20:16:39 GMT

Your sample doesnt work if I use guid generator. I think this sample is not correct way using one-to-one mapping.

Ayende Rahien commented on NHibernate Mapping -

Mon, 20 Apr 2009 08:25:12 GMT

Nik, Yes, it is possible. Take care to ensure that it is always set to A person, if you are using constrained, though. Chris, Use the Where property

Chris commented on NHibernate Mapping -

Sun, 19 Apr 2009 15:38:21 GMT

How do you emulate a one to many relationship in ActiveRecord, where you need to filter the key based on a column? For example my MailAccount has lots of Contacts, but I only want to those Contacts of a particular type in the relationship? From what I can see it's not possible in AR, but is in NH.

Steve Willcock commented on NHibernate Mapping -

Sun, 19 Apr 2009 11:40:11 GMT

Great explanation, the constrained="true" / foreign-key="none" part is really helpful.

Nik commented on NHibernate Mapping -

Sun, 19 Apr 2009 08:18:55 GMT

Hi. Is it possible set new Employee on existing Person? Thanks for reply.