private static void AddHomeworks(int homeworksCount) { var dbContext = new StudentsSystemDbContext(); var coursesIds = dbContext.Courses .Select(c => c.Id) .ToList(); int coursesIdsCount = coursesIds.Count; var studentsIds = dbContext.Students .Select(st => st.Id) .ToList(); for (int i = 0; i < homeworksCount; i++) { var hw = new Homework(); hw.Content = RandomDataGenerator.GetString(1, 500); int courseIndex = RandomDataGenerator.GetInteger(0, coursesIdsCount - 1); hw.CourseId = coursesIds[courseIndex]; // works while students count is equal or greater than homeworks count hw.StudentId = studentsIds[i]; dbContext.Homeworks.Add(hw); if (i % 100 == 0) { dbContext.SaveChanges(); dbContext.Dispose(); dbContext = new StudentsSystemDbContext(); } } dbContext.SaveChanges(); }
private static void AddStudents(int studentsCount) { var dbContext = new StudentsSystemDbContext(); for (int i = 0; i < studentsCount; i++) { var student = new Student(); student.FirstName = RandomDataGenerator.GetString(2, 10); student.LastName = RandomDataGenerator.GetString(2, 15); student.FacultyNumber = RandomDataGenerator.GetString(10, 10); dbContext.Students.Add(student); if (i % 100 == 0) { dbContext.SaveChanges(); dbContext.Dispose(); dbContext = new StudentsSystemDbContext(); } } dbContext.SaveChanges(); }