Entity Framework Bug?

Question

I'm not sure if this is a bug or a feature of Entity Framework.

I created 2 tables without Ids. I don't see these tables in my diagram but if I try remove all tables, Visual Studio shows me the table names.

Answer 1

If you have a many to many relationship that relationship is modeled in the database by using a table to do the mappings between the two tables. It is likely your table was turned in to one of those "look up" tables.

So something like this

Turns in to this