Now, let's look at the models that have many-to-many relationships. The Employees
table and the Reports
table have a many-to-many relationship. If we look at the Employer
and Report
relationship, we can see that the Entity Framework Entity Data Model generator was able to figure out this many-to-many relationship between these tables and was able to create the same relationship in the conceptual Entity Data Model as well.
The important thing to notice here is that the Entity Framework was also able to understand that the EmployeeReports
table was created solely to manage a many-to-many relationship, and is actually not needed in the conceptual model.