private static void ShowCase_Insert(ExampleDbContext dbContext) { var teachers = dbContext.Teachers .Add(new[] { new Teacher("test_name", "test_firstname", Gender.MALE, new DateTime(2000, 1, 1), 2500), new Teacher("test_name2", "test_firstname2", Gender.FEMALE, new DateTime(2002, 2, 2), 2600) }) .Build() .Execute(); var cl = dbContext.Classes .Add(new Class("1A")) .Build() .Execute() .First(); var student = dbContext.Students .Add(new Student("test_name3", "test_firstname3", Gender.MALE, new DateTime(2003, 3, 3))) .Build() .Execute() .First(); var course = dbContext.Courses .Add(new Course(true, "best course")) .Build() .Execute() .First(); dbContext.SaveChanges(); var teacher = teachers.First(); //teacher.Classes.Add(cl); cl.Teacher = teacher; // equivalent result //course.Teacher = teacher; teacher.Courses.Add(course); // equivalent result //student.Class = cl; cl.Students.Add(student); // equivalent result //student.Courses.Add(course); course.Students.Add(student); // equivalent result dbContext.SaveChanges(); }
private static void ShowCase_Change_Multiple(ExampleDbContext dbContext) { var ps = dbContext.Persons .Select() .Build() .Execute() .ToList(); ps.ForEach(p => p.FirstName = "changed"); dbContext.SaveChanges(); var ps2 = dbContext.Persons .Select() .Build() .Execute() .ToList(); }