title: Entity Framework Associations: Error Because the Dependent Role properties are not the key properties
body: <p>Using Entity Framework 4.1</p>
  
  <p>I have the following tables I'm using with Entity Framework</p>
  
  <ul>
  <li><p><strong>User</strong> ( UserId PK identity, UserName, Password )</p></li>
  <li><p><strong>Physician</strong> ( PhysicianId unique identity, UserId refereces User PK, PhysicianName )</p></li>
  <li><p><strong>PhysicianSite</strong> ( SiteId, Location, PhysicianId FK to Physician table)</p></li>
  </ul>
  
  <p>Problem. Entity Framework would not allow me to associate Physician with PhysicianSite because PhysicianId is not the primary key on the Physician table.</p>
  
  <p>User is the base of Physician because my application has other types Users, such as Patients.</p>
  
  <p>I get the following error</p>
  
  <p>Error   2   Error 113: Multiplicity is not valid in Role 'Physician' in relationship 'PhysicianSitePhysician'. Because the Dependent Role properties are not the key properties, the upper bound of the multiplicity of the Dependent Role must be *.   </p>
  
  <p>Could someone tell me how I can create the association with Physician to PhysicianSite <strong>in Entity Framework</strong> without PhysicianId being the primary key on the Physician table?</p>