Insert/Update Many to Many Entity Framework . How do I do it?

by

In terms of entities (or objects) you have a Class object which has a collection of Students and a Student object that has a collection of Classes. Since your StudentClass table only contains the Ids and no extra information, EF does not generate an entity for the joining table. That is the correct behaviour and that’s what you expect.

Now, when doing inserts or updates, try to think in terms of objects. E.g. if you want to insert a class with two students, create the Class object, the Student objects, add the students to the class Students collection add the Class object to the context and call SaveChanges:

using (var context = new YourContext())
{
    var mathClass = new Class { Name = "Math" };
    mathClass.Students.Add(new Student { Name = "Alice" });
    mathClass.Students.Add(new Student { Name = "Bob" });

    context.AddToClasses(mathClass);
    context.SaveChanges();
}

This will create an entry in the Class table, two entries in the Student table and two entries in the StudentClass table linking them together.

You basically do the same for updates. Just fetch the data, modify the graph by adding and removing objects from collections, call SaveChanges. Check this similar question for details.

Edit:

According to your comment, you need to insert a new Class and add two existing Students to it:

using (var context = new YourContext())
{
    var mathClass= new Class { Name = "Math" };
    Student student1 = context.Students.FirstOrDefault(s => s.Name == "Alice");
    Student student2 = context.Students.FirstOrDefault(s => s.Name == "Bob");
    mathClass.Students.Add(student1);
    mathClass.Students.Add(student2);

    context.AddToClasses(mathClass);
    context.SaveChanges();
}

Since both students are already in the database, they won’t be inserted, but since they are now in the Students collection of the Class, two entries will be inserted into the StudentClass table.

More Related Contents:

  1. Create code first, many to many, with additional fields in association table
  2. How to create a many-to-many mapping in Entity Framework?
  3. Many-to-many mapping table
  4. Self-referencing many-to-many recursive relationship code first Entity Framework
  5. How to define Many-to-Many relationship through Fluent API Entity Framework?
  6. MVC 4 – Many-to-Many relation and checkboxes
  7. Using Transactions or SaveChanges(false) and AcceptAllChanges()?
  8. Entity Framework change connection at runtime
  9. Entity Framework async operation takes ten times as long to complete
  10. Entity Framework Provider type could not be loaded?
  11. Entity Framework DateTime and UTC
  12. Linq to Entities, random order
  13. Can I reuse code for selecting a custom DTO object for a child property with EF Core?
  14. How to Bulk Update records in Entity Framework?
  15. How to declare one to one relationship using Entity Framework 4 Code First (POCO)
  16. Understanding ForeignKey attribute in entity framework code first
  17. Mapping Database Views to EF 5.0 Code First w/Migrations
  18. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  19. EF migration for changing data type of columns
  20. Entity Framework Queryable async
  21. Delete a single record from Entity Framework?
  22. Entity framework raw SQL Query
  23. How to Identify the primary key duplication from a SQL Server 2008 error code?
  24. Entity Framework 4.1: Unable to cast from DbQuery to ObjectQuery
  25. Unable to find the requested .Net Framework Data Provider. It may not be installed
  26. Cannot find command ‘dotnet ef’
  27. Testing an Entity Framework database connection
  28. Should the order of LINQ query clauses affect Entity Framework performance?
  29. How should I access a computed column in Entity Framework Code First?
  30. Why Entity Framework performs faster than Dapper in direct select statement [closed]

Leave a Comment