// 插入新的course到现存的department public static void InsertCourse() { using (EFO2MEntities context = new EFO2MEntities()) { Course course = new Course() { CourseID = 2203, Title = "Object Oriented Programming" }; course.Department = ( from p in context.Department where p.DepartmentID == 7 select p).First(); context.AddToCourse(course); try { Console.WriteLine("Inserting course {0} to department " + "{1}", course.Title, course.Department.Name); context.SaveChanges(); Query(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
// 插入新的department包括新的course public static void InsertDepartmentWithCourse() { using (EFO2MEntities context = new EFO2MEntities()) { Department department = new Department() { DepartmentID = 4, Name = "Software Engineering" }; Course course = new Course() { CourseID = 2202, Title = "ADO.NET" }; department.Course.Add(course); context.AddToDepartment(department); try { Console.WriteLine("Inserting department {0} with course " + "{1}", department.Name, course.Title); context.SaveChanges(); Query(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } }
// 更新一个现存的course public static void UpdateCourse() { using (EFO2MEntities context = new EFO2MEntities()) { Course course = new Course(); course.CourseID = 2203; context.AttachTo("Course", course); course.Title = "OOP"; try { Console.WriteLine("Modifying Course 2203's Title to {0}", course.Title); context.SaveChanges(); Query(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } }