Loading

how to insert data into many to many table using EF.

Sharma Raushan

I have three tables

Student
Course
StudentCourse

student table has already some data, course table has some data, now i want to assign a particular course to a student.But when i add data it creates a new row in the tables how to solve this??

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
please use below method to insert data into your bridge table
public static void SaveBridge(int StudentId,int CourseID)
        {
            YourContext db = new YourContext ();
            var student = db.Students.Find(StudentId);
            var course = db.Courses.Find(CourseID);
          student.Courses.Add(course);
          db.Entry(student).State = System.Data.Entity.EntityState.Modified;
          db.SaveChanges();


        }