Well, I have tried to do a Many-to-Many relationship using Entity framework, where the Join table has more than just two ID, it will have two other columns Active and DateUpdate. So here is the designer.
When I did the context importing from an existing database, it look to work well. But I got a big question, is it right have the direction going from Group[0].GroupUser[0].User and going back in the same case? And in that way creating a lot of redundancy has showed in the picture below? Or is it something wrong?
It is not redundancy.
Group[0].GroupUser[0].User
is a reference toUser
andUser
has a navigation property to theGroupUser
. Therefore, when you seeUser
and then navigate toGroupUser
of that user, theGroupUser
will have a reference toUser
. If you keep expanding, it will keep showing you the sameUser
andGroupUser
.