public static void Initialize(NetCoreDemoDbConttext context) { context.Database.EnsureCreated(); // 如果有数据则 不执行数据初始化 if (context.Students.Any()) { return; } var students = new Student[] { new Student { Name = "张三", Email = "[email protected]" }, new Student { Name = "李四", Email = "[email protected]" }, new Student { Name = "王五", Email = "[email protected]" }, new Student { Name = "赵六", Email = "[email protected]" }, new Student { Name = "刘希", Email = "[email protected]" } }; context.Students.AddRange(students); context.SaveChanges(); var courses = new Course[] { new Course { Name = "数学", CreationTime = DateTime.Now, CourseGrade = Application.EnumsType.Grade.A }, new Course { Name = "语文", CreationTime = DateTime.Now, CourseGrade = Application.EnumsType.Grade.A }, new Course { Name = "化学", CreationTime = DateTime.Now, CourseGrade = Application.EnumsType.Grade.A }, new Course { Name = "英语", CreationTime = DateTime.Now, CourseGrade = Application.EnumsType.Grade.A }, new Course { Name = "地理", CreationTime = DateTime.Now, CourseGrade = Application.EnumsType.Grade.A }, new Course { Name = "物理", CreationTime = DateTime.Now, CourseGrade = Application.EnumsType.Grade.A } }; context.Courses.AddRange(courses); context.SaveChanges(); var achieventments = new Achievement[] { new Achievement { StudentId = 1, CourseId = 1, Grade = Application.EnumsType.Grade.A }, new Achievement { StudentId = 1, CourseId = 2, Grade = Application.EnumsType.Grade.A }, new Achievement { StudentId = 1, CourseId = 3, Grade = Application.EnumsType.Grade.G }, new Achievement { StudentId = 1, CourseId = 4, Grade = Application.EnumsType.Grade.A }, new Achievement { StudentId = 1, CourseId = 5, Grade = Application.EnumsType.Grade.B }, new Achievement { StudentId = 1, CourseId = 6, Grade = Application.EnumsType.Grade.F }, new Achievement { StudentId = 2, CourseId = 2, Grade = Application.EnumsType.Grade.A }, new Achievement { StudentId = 2, CourseId = 3, Grade = Application.EnumsType.Grade.C }, new Achievement { StudentId = 2, CourseId = 4, Grade = Application.EnumsType.Grade.D }, new Achievement { StudentId = 2, CourseId = 5, Grade = Application.EnumsType.Grade.F }, new Achievement { StudentId = 2, CourseId = 6, Grade = Application.EnumsType.Grade.E }, new Achievement { StudentId = 3, CourseId = 1, Grade = Application.EnumsType.Grade.A }, new Achievement { StudentId = 3, CourseId = 3, Grade = Application.EnumsType.Grade.B }, new Achievement { StudentId = 4, CourseId = 4, Grade = Application.EnumsType.Grade.B }, new Achievement { StudentId = 4, CourseId = 2, Grade = Application.EnumsType.Grade.C }, new Achievement { StudentId = 5, CourseId = 1, Grade = Application.EnumsType.Grade.E }, new Achievement { StudentId = 5, CourseId = 4, Grade = Application.EnumsType.Grade.F }, new Achievement { StudentId = 5, CourseId = 1, Grade = Application.EnumsType.Grade.E }, }; context.Achievements.AddRange(achieventments); context.SaveChanges(); }
public StudentsController(NetCoreDemoDbConttext context) { _context = context; }