c.Association Table Mapping

  1. Motivation
    1. Maps many to many association in between the tables (Link Table Mapping).
  2. Summary
    1. Association table is a link table that just contains IDs of Foreign keys of tow tables.
    2. In Business object it is mapped with tow way "Foreign Key Mapping" approach i.e. parent to child and child to parent.
    3. ORM Frameworks like EF provides out of the box implementation for such cases
    4.  Data Model   Business Model 
       
       

  3. When to Use
    1. whnt you have many to many mapping in between data base tables
  4. References
    1. http://msdn.microsoft.com/en-us/library/dd742359(v=vs.100).aspx