title: Many-to-many relationships in Entity Framework where join table has more than two fields?
body: <p>I am importing a database into Entity Framework and I'm having trouble with a many-to-many relationship that looks like this:
  <img src="https://i.stack.imgur.com/sBDrW.png" alt=""></p>
  
  <p>My understanding is that if the "join table" (the middle one) contains only two fields (the foreign keys) then EF will automatically remove the middle table and create a many-to-many relationship. Unfortunately I don't have control over the database schema, so does anyone know if there's a way to replicate that behaviour manually?</p>
  
  <p>For the record, there is no purpose behind that Id field in Employee_Employee_Type, it's just poorly designed.</p>