NHibernate Mapping intermediary table

Question

Hi I'm looking for some help in mapping the following tables to a hibernate mapping file: schema image http://barry-jones.com/temp/sch2.jpg

I'm trying to fill the localCalandarGroups List with related localCalendarGroups when loading my userVOs. I'm using a intermediary table(user_localCalendarGroup) to keep the user and localCalendarGroup ids

 public class UserVO { public virtual int id { get; set; } public virtual string name { get; set; } public virtual string pass { get; set; } public virtual string email { get; set; } public virtual string level { get; set; } public virtual List<LocalCalendarGroupVO> localCalendarGroups { get; set; } } public class LocalCalendarGroupVO { public virtual int id { get; set; } public virtual string name { get; set; } }

This is my mapping file thus far. How can I make NHibernate aware of the intermediary table?

 <class name="UserVO" table="tb_users" lazy="false"> <id name="id" column="id"> <generator class="native" /> </id> <property name="name" /> <property name="pass" /> <property name="level" /> <property name="email" /> <property name="localCalendarGroups"/>

Any help,pointers much appreciated.

Darin Dimitrov · Accepted Answer · 2008-12-30 08:44:28Z

The first thing I would suggest you is using IList instead of List for mapping the localCalendarGroups association in your domain classes. This will enable lazy loading the collection. And here's the mapping file for the UserVO class:

<class name="UserVO" table="tb_users"> <id name="id" column="id"> <generator class="native" /> </id> <property name="name" /> <property name="pass" /> <property name="level" /> <property name="email" /> <bag name="localCalendarGroups" table="user_localCalendarGroup"> <key column="userID" /> <many-to-many class="LocalCalendarGroupVO" column="calID" /> </bag> </class>

And the corresponding class definition:

public class UserVO { public virtual int id { get; set; } public virtual string name { get; set; } public virtual string pass { get; set; } public virtual string email { get; set; } public virtual string level { get; set; } public virtual IList<LocalCalendarGroupVO> localCalendarGroups { get; set; } }

Thanks for this. Unfortunately I keep getting a mapping exception though. I'll have a play around and see if I can't solve it. Once again thanks.

user17510 · Accepted Answer · 2008-12-30 11:44:26Z

This page has a fairly good explanation.

http://codebetter.com/blogs/peter.van.ooijen/archive/2008/05/29/nhibernate-many-to-many-collections-or-mapping-is-not-one-table-one-class.aspx

Collectives™ on Stack Overflow

NHibernate Mapping intermediary table

2 Answers 2

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Related