locked
storing values to brigding tables! RRS feed

  • Question

  • hi friends,

    assume i have the following table strucutre and relationship to demonstrate M : N relationship:

     

    From fv

     

    The relation is between the roles and the user and their briedgig entity. when i save a new user the form allocated the roles, (and only role_id are passed to tbe backend).

    In this, DAL, i have written a method to generate a xml document that of following structure and values:

    <Roles><id>10</id><id>20</id></Roles>

    But in the bridging table UsersUserRoles contain another column called "special notes", XML was generated to store all the ROles of teh saving user, the id values in the xml document will be saved to the UserUserRoles. But since the bridging table has the column SpcialNotes should i also add an element <specialnotes> to the xml document?

    thanks

     

     

    Thursday, September 23, 2010 10:53 AM

Answers

  • if you dont think that it would be needed some where for processing , then dont use it
    • Marked as answer by code_warrior Saturday, September 25, 2010 3:50 AM
    Thursday, September 23, 2010 11:04 AM