Almost every project requires the use of many to many relationships and LINQ to SQL does not support it. As you probably guessed, PLINQO does! Let's go
through a quick sample of a many to many scencario in PLINQO. Below is a diagram of a many to many relationship between the User and Role entities.
The UserRole table before any many to many code is executed.
The code here adds a User to a Role.
using (var context = new TrackerDataContext())
{
User u = context.User.GetByKey(1);
Role r = context.Role.GetByKey(1);
u.RoleList.Add(r);
context.SubmitChanges();
}
The result in the database after the code is executed.
Read more about how PLINQO implemented many to many relationships.