static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentsSystemContext, Configuration>());
using (StudentsSystemContext dbContext = new StudentsSystemContext())
{
var firstHomework = new Homework()
{
Content = "Simple database1",
TimeSent = DateTime.Now,
};
var secondHomework = new Homework()
{
Content = "Simple database2",
TimeSent = DateTime.Now,
};
var student = new Student()
{
FirstName = "Nikolay",
LastName = "Kostadinov",
Number = "965552",
};
var course = new Course()
{
Name = "DataBase",
Description = "Entity Framework Code First",
Materials = "Lections, homework"
};
student.Homeworks.Add(firstHomework);
student.Homeworks.Add(secondHomework);
student.Courses.Add(course);
course.Homeworks.Add(secondHomework);
course.Students.Add(student);
dbContext.Students.Add(student);
dbContext.Courses.Add(course);
dbContext.Homeworks.Add(firstHomework);
dbContext.Homeworks.Add(secondHomework);
dbContext.SaveChanges();
}
}
public IHttpActionResult Create(HomeworkModel item)
{
if (!this.ModelState.IsValid)
{
return BadRequest(ModelState);
}
var newItem = new Homework()
{
Content = item.Content,
};
this.data.Homeworks.Add(newItem);
this.data.Homeworks.SaveChanges();
item.ID = newItem.ID;
return Ok(item);
}
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();
}
