hi,
I am quite new in nhibernate and have a question:
I have 3 tables:

1 - Voters (VoterId, name1, ...)
2 - Customers (customerId, name2, . . .)
3 - VoterCustomer (VoterId, customerId, name3 and additional columns)

I have been confused between : set, bag, many-to-many, ...
and I do not know how and where to define the name3 and additional columns ?
I have class Voter which has: name1, name3, and additional columns

Thanks!

if you have additional columns this really isn't a typical many-to-many mapping. I'd go for a one-to-many on both sides, both referring to entities which represent the link + the additional columns

Thanks for your quick reply !
Actualy it's a bit more complex:

In table "Voters" I have composite PK: VoterID+CustomerID,
when this happens, the relation to "VoterCustomer" table, is 'one-to-one'.
because in "VoterCustomer" I have the same composite PK: VoterID+CustomerID.
(I have a reason why do not merge to an one table.)
So, how do I define such a mapping with two composite PK ?

Thanks a lot !

what exactly do you mean with 'when this happens'? If the primary key of Voter consists of VoterID + CustomerID, and the primary key of VoterCustomer is also VoterID + CustomerID then shouldn't it always be a one-to-one relation?

You are right in principle, but I want to say something like that:

In "Voters" table:
if customerId = 0, then this voter has no appropriate voterCustomer row,
else,
the VoterId+CustomerId will be the PK in VoterCustomer.
How can I define a mapping like that?

I tried to define :
<one-to-one name="voterCustomer" class="LocalDll.VoterCustomer" outer-join="auto" property-ref="order"/>
what's the meaning of the attribute: property-ref ?
and if I have composite PK, how to define it ?

thanks!

i don't know if you can define a mapping like that... i still don't understand why you'd want to do it this way