Asp.net membership Table: aspnet_UsersInRoles not showing up in Enity Framework designer

Question

I made an Entity database and it generated all the tables but it seems to have forgotten about the aspnet_usersinRoles table.

I don't know why it would skip this one or how to add it.

When in I look in the Model Browser through VS2008 I see the the aspnet_UsersInRoles table.

Answer 1

No, it didn't "forget" about aspnet_UsersInRoles. This table consists only of two foreign keys to other tables. Since you've mapped those as well, aspnet_UsersInRoles is subsumed into a many to many relationship within your model. In other words, it's there; it just isn't shown as a separate entity, since it serves only to represent a relationship between two other entities.