many to many relationship with ORM

[aung maw]

Hi All,  I have two tables.   Employee and Position.  When I establish many to many relationship, ORM would create Employee_Position table with Employee_Id, Position_Id and seq_num primary keys.  My question is how can I add another fields like DateEffective & DateExpiration in Employee_Position to track the time each employee used for the positions.  I can't seem to find Employee_Position table in "Forward Mapping (Classes to Tables).  Please help.

Many Thanks,

[Ady]

Hello aung maw,

 You can have a look at this KB article that explains how to map a m:n relationship with extra information.

Hope this helps.

Greetings,
Ady
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

[aung maw]

Hi Ady, This is great. Thanks so much.  Regards,