Yes, regarding the msdn-article, the PlayersInTeam is a pure-join-table (PJT) and should be eliminated by the many-to-many relationship between "Player" and "Team". This doesn't work in VS 2010 datamodel-designer. The entity "PlayersInTeams" is present,
also the two one-to-many relations between "Player" and "PlayersInTeams" and between "Team" and "PlayersInTeams". BTW: The model is created from a underlying MS SQL-server database.
How can I create the many-to-many-realationship in the datamodel designer?
Tillmann
Member
19 Points
16 Posts
Re: Creating a Filter for Foreign-Key-Only Tables
Apr 26, 2012 04:19 PM|LINK
Yes, regarding the msdn-article, the PlayersInTeam is a pure-join-table (PJT) and should be eliminated by the many-to-many relationship between "Player" and "Team". This doesn't work in VS 2010 datamodel-designer. The entity "PlayersInTeams" is present, also the two one-to-many relations between "Player" and "PlayersInTeams" and between "Team" and "PlayersInTeams". BTW: The model is created from a underlying MS SQL-server database.
How can I create the many-to-many-realationship in the datamodel designer?
Regards
Tillmann