Many-to-many relationships in Entity Framework where join table has more than two fields?
I am importing a database into Entity Framework and I'm having trouble with a many-to-many relationship that looks like this:
![][1]

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?

For the record, there is no purpose behind that Id field in Employee_Employee_Type, it's just poorly designed.


  [1]: http://i.stack.imgur.com/sBDrW.png
Many-to-many relationships in Entity Framework where join table has more than two fields?
===

I am importing a database into Entity Framework and I'm having trouble with a many-to-many relationship that looks like this:
![][1]

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?

For the record, there is no purpose behind that Id field in Employee_Employee_Type, it's just poorly designed.


  [1]: http://i.stack.imgur.com/sBDrW.png