public void Seed(int count)
{
Console.Write("Importing students:");
var db = new StudentsSystemDbContext();
for (int i = 0; i < count; i++)
{
var student = new Student
{
Name = RandomGenerator.GetRandomString(10, 50),
Number = RandomGenerator.GetRandomString(10, 10)
};
db.Students.Add(student);
if (i % 10 == 0)
{
Console.Write(".");
}
if (i % 100 == 0)
{
db.SaveChanges();
db.Dispose();
db = new StudentsSystemDbContext();
}
}
db.SaveChanges();
Console.WriteLine();
}
public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentsSystemDbContext, Configuration>());
var db = new StudentsSystemDbContext();
db.Courses.Count();
}
public void Seed(int count)
{
Console.Write("Importing homeworks:");
var db = new StudentsSystemDbContext();
var allStudentIds = db
.Students
.Select(s => s.Id)
.ToList();
for (int i = 0; i < count; i++)
{
var studentId = RandomGenerator.GetRandomNumber(0, allStudentIds.Count - 1);
var homework = new Homework
{
Content = RandomGenerator.GetRandomString(50, 150),
TimeSent = RandomGenerator.GetRandomDate(before: DateTime.Now),
StudentId = allStudentIds[studentId]
};
db.Homeworks.Add(homework);
if (i % 10 == 0)
{
Console.Write(".");
}
if (i % 100 == 0)
{
db.SaveChanges();
db.Dispose();
db = new StudentsSystemDbContext();
}
}
db.SaveChanges();
Console.WriteLine();
}
public void Seed(int count)
{
Console.Write("Importing courses:");
var db = new StudentsSystemDbContext();
var allStudents = db
.Students
.OrderBy(s => Guid.NewGuid())
.ToList();
var allHomeworks = db
.Homeworks
.OrderBy(h => Guid.NewGuid())
.ToList();
for (int i = 0; i < count; i++)
{
var currentStudentInCourse = RandomGenerator.GetRandomNumber(10, 30);
var currentStartIndex = RandomGenerator.GetRandomNumber(0,
allStudents.Count - currentStudentInCourse - 1);
var studentsList = new HashSet<Student>();
for (int j = 0; j < currentStudentInCourse; j++)
{
studentsList.Add(allStudents[currentStartIndex]);
currentStartIndex++;
}
var currentHomeworsInCourse = RandomGenerator.GetRandomNumber(5, 15);
currentStartIndex = RandomGenerator.GetRandomNumber(0,
allHomeworks.Count - currentHomeworsInCourse - 1);
var homeworksList = new HashSet<Homework>();
for (int j = 0; j < currentHomeworsInCourse; j++)
{
homeworksList.Add(allHomeworks[currentStartIndex]);
currentStartIndex++;
}
var course = new Course
{
Name = RandomGenerator.GetRandomString(10, 100),
Description = RandomGenerator.GetRandomString(50, 500),
Students = studentsList,
Homeworks = homeworksList
};
db.Courses.Add(course);
if (i % 10 == 0)
{
Console.Write(".");
}
if (i % 100 == 0)
{
db.SaveChanges();
db.Dispose();
db = new StudentsSystemDbContext();
}
}
db.SaveChanges();
Console.WriteLine();
}