Hibernate version: v.1.2.0.Alpha1

Assume I have 3 table Contact(ContactID),Category(CategoryID) and table for relate CategoryContact(ContactID[\u],[u]CategoryID)

Mapping file:
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0" default-access="property">
<class name="TestNHibernate.Category, TestNHibernate" table="Categories">
<id name="Id" column="CategoryId">
<generator class="assigned" />
</id>
<property name="Description" column="CatDesc" />
<bag name="Contacts" table="CategoryContacts" cascade="none" access="nosetter.camelcase" lazy="false" inverse="true">
<key column="CategoryId" />
<many-to-many column="ContactID" class="TestNHibernate.Contact, TestNHibernate" />
</bag>
</class>

<class name="TestNHibernate.Contact, TestNHibernate" table="Contacts" discriminator-value="?" >
<id name="Id" column="ContactId" access="nosetter.camelcase" unsaved-value="0">
<generator class="identity" />
</id>
<discriminator column="ContactType" />
<property name="Name" column="ContactName" />
<bag name="Categories" table="CategoryContacts" cascade="none" access="nosetter.camelcase" lazy="false" inverse="false">
<key column="ContactId" />
<many-to-many column="CategoryId" class="TestNHibernate.Category, TestNHibernate" />
</bag>
</class>
</hibernate-mapping>

File class:
Category.cs
public class Category
{
private string id;
private string description;
private IList contacts = new ArrayList(); public string Id {
get { return this.id; }
set { this.id = value; }
}

public string Description {
get { return this.description; }
set { this.description = value; }
}

public IList Contacts {
get { return this.contacts; }
}
}
Contact.cs
public class Contact
{
private int id;
private string name;
private IList categories = new ArrayList(); public int Id {
get { return this.id; }
}

public string Name {
get { return this.name; }
set { this.name = value; }
}

public IList Categories {
get { return this.categories; }
}

}

Not at all when I Insert into Contact and Category table, CategoryContact will have a new row consist of ContactID and CategoryID values automatically.

But, my problem is if CategoryContact table have more fields, ex: Quantity field
CategoryContact will become:
CategoryContact(ContactID,CategoryID,Quantity,...)
I cant add data for Quantity column

Any body help me, whether the same example or your solutions...
Thank you so much!

you have to break the many-to-many into 2 one-to-many and your CategoryContact will become an entity on which you can map any number of properties.

cheers,
radu

Thank you!
But dont want to break into 2 one-to-many
I found that can use double key with <composite-id> tag but I dont know how to solve:
<composite-id>
<key-many-to-one name="Contact" column="ContactID" class="TestNHibernate.Contact, TestNHibernate"/>
<key-many-to-one name="Category" column="CategoryID" class="TestNHibernate.Category, TestNHibernate"/>
</composite-id>

vantamvtf

There is one way to use many-to-many by using Ayende Generics that overrides the default accessor.



Notice the Key element AccessType that is part of the relation table.
This XML will appear in classes as: