private void InitDb() { var isNeedAddData = false; using (var context = new EfCommonTestDb()) { if (context.Database.Exists() == false) { context.Database.Create(); isNeedAddData = true; } } if (isNeedAddData) { AddData(); } }
public void AddData() { using (var db = new EfCommonTestDb()) { List <Teacher> teachers = new List <Teacher>(); for (int i = 0; i < 1000; i++) { teachers.Add(new Teacher() { Age = i.ToString(), Name = "Teacher" + i.ToString() }); } db.Teachers.AddRange(teachers); db.SaveChanges(); var teas = db.Teachers.ToList(); List <Student> students = new List <Student>(); for (int i = 0; i < 10; i++) { for (int j = 0; j < 100; j++) { var r = new Random(j); var stu = new Student() { //Id = 1, Age = (j + i).ToString(), Name = "张三" + j.ToString(), Teachers = new List <Teacher>() { teas[r.Next(teas.Count())], teas[r.Next(teas.Count())], teas[r.Next(teas.Count())] } }; students.Add(stu); } } db.Students.AddRange(students); db.SaveChanges(); var stus = db.Students.Select(t => t.Id).ToList(); List <Score> scores = new List <Score>(); if (stus.Count() > 0) { for (int z = 0; z < 10000; z++) { var r = new Random(z); var score = new Score() { ChineseFraction = r.Next(100), CreateTime = DateTime.Now, EnglishFraction = r.Next(100), MathematicsFraction = r.Next(100), ScoreTyep = (ScoreTyep)r.Next(0, 2), TeacherComment = GetTeacherComment(r), StudentId = stus[r.Next(stus.Count())] }; scores.Add(score); } } db.Scores.AddRange(scores); db.SaveChanges(); } }
public EfCommonTest() { InitDb(); dbContext = new EfCommonTestDb(); }