many to many relationship with ORM

Thread is closed for posting
3 posts, 0 answers
  1. aung maw
    aung maw avatar
    18 posts
    Member since:
    Apr 2006

    Posted 10 Apr 2009 Link to this post

    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,

  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 10 Apr 2009 Link to this post

    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.
  3. aung maw
    aung maw avatar
    18 posts
    Member since:
    Apr 2006

    Posted 10 Apr 2009 Link to this post

    Hi Ady, This is great. Thanks so much.  Regards,
Back to Top