How would you do a many-to-many association with MongoDB?
For example; let's say you have a Users table and a Roles table. Users have many roles, and roles have many users. In SQL land you would create a UserRoles table.
Users:
Id
Name
Roles:
Id
Name
UserRoles:
UserId
RoleId
How is same sort of relationship handled in MongoDB?
Best Answer
Depending on your query needs you can put everything in the user document:
To get all the Engineers, use:
If you want to maintain the roles in separate documents then you can include the document's _id in the roles array instead of the name:
and set up the roles like: