One to one mapping with an intermediate table

[Roni Dover]

Hi!

I'm trying to find the correct way to map a one-to-one relationship
using an inbetween table.
For example, I have a Person table and a PersonConnection table (the
separate table is needed because the connection itself also has
properties). Each person can have only one connection with one other
person.
I'd also like the PersonConnection entry to be treated as "Orphan" and
deleted if both of the Person entries it connects are deleted.

I'd appreciate any ideas!

[James Gregory]

I think you've really got a many-to-many there, with some artificial restrictions in your domain. You either need to create an entity for your intrim table, and then create two one-to-one's, or just map it as a many-to-many. If you go the m2m route you could map it as a field and create a property that just exposes the first item, but that's a little hackish.