protected void Button1_Click(object sender, EventArgs e)
{
StudentDBContext employeeDBContext = new StudentDBContext();
employeeDBContext.Database.CommandTimeout = 540;
Course WCFCourse = employeeDBContext.Courses
.FirstOrDefault(x => x.CourseID == 4);
employeeDBContext.Students.Include("Courses")
.FirstOrDefault(x => x.StudentID == 1).Courses.Add(WCFCourse);
employeeDBContext.SaveChanges();
}
protected void Button2_Click(object sender, EventArgs e)
{
StudentDBContext employeeDBContext = new StudentDBContext();
employeeDBContext.Database.CommandTimeout = 540;
Course SQLServerCourse = employeeDBContext.Courses
.FirstOrDefault(x => x.CourseID == 3);
employeeDBContext.Students.Include("Courses")
.FirstOrDefault(x => x.StudentID == 2).Courses.Remove(SQLServerCourse);
employeeDBContext.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
StudentDBContext employeeDBContext = new StudentDBContext();
employeeDBContext.Database.CommandTimeout = 540;
GridView1.DataSource = (from student in employeeDBContext.Students
from c in student.Courses
select new
{
student.StudentName,
c.CourseName
}).ToList();
GridView1.DataBind();
}
