protected void Button2_Click(object sender, EventArgs e) { StudentDBContext studentDBContext = new StudentDBContext(); StudentCourse studentCourseToRemove = studentDBContext.StudentCourses .FirstOrDefault(x => x.StudentID == 2 && x.CourseID == 3); studentDBContext.StudentCourses.Remove(studentCourseToRemove); studentDBContext.SaveChanges(); }
protected void Button1_Click(object sender, EventArgs e) { StudentDBContext studentDBContext = new StudentDBContext(); studentDBContext.StudentCourses.Add(new StudentCourse { StudentID = 1, CourseID = 4, EnrolledDate = DateTime.Now }); studentDBContext.SaveChanges(); }
protected void Page_Load(object sender, EventArgs e) { StudentDBContext studentDBContext = new StudentDBContext(); studentDBContext.Database.CommandTimeout = 540; GridView1.DataSource = (from student in studentDBContext.Students from studentCourse in student.StudentCourses select new { student.StudentName, studentCourse.Course.CourseName, studentCourse.EnrolledDate }).ToList(); GridView1.DataBind(); }