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();
}
