public StudentCourse(Student student, Course course)
{
StudentId = student.Id;
Student = student;
CourseId = course.Id;
Course = course;
}
public async Task SeedData()
{
if (await this.ctx.Students.CountAsync() > 0) return;
for (int i = 1; i <= 100; i++)
{
var student = new Student { Name = $"Student {i}" };
var course = new Course { Name = $"Course {i}" };
this.ctx.Students.Add(student);
this.ctx.Courses.Add(course);
this.logger.LogInformation($"Adding Student {student.Name}");
this.logger.LogInformation($"Adding Course {course.Name}");
}
logger.LogInformation("Saving...");
await this.ctx.SaveChangesAsync();
var students = await this.ctx.Students.ToListAsync();
foreach (var student in students)
{
for (int i = 1; i <= 50; i++)
{
var course = await this.ctx.Courses.Where(c => c.Name.Equals($"Course {i}")).FirstOrDefaultAsync();
if (course != null)
{
var studentCourse = new StudentCourse(student, course);
this.ctx.StudentCourses.Add(studentCourse);
this.logger.LogInformation($"Linking {student.Name} with {course.Name}");
}
}
}
logger.LogInformation("Saving...");
await this.ctx.SaveChangesAsync();
this.logger.LogInformation("Done!");
}