public StudentsController()
{
this.db = new StudentsDbContext();
this.students = new EfGenericRepository<Student>(this.db);
this.homeworks = new EfGenericRepository<Homework>(this.db);
this.courses = new EfGenericRepository<Course>(this.db);
}
private static void SeedData(StudentsDbContext dbContext)
{
var generator = new DataGenerator();
var students = generator.GenerateStudents(10);
var courses = generator.GenerateCourses(10);
var index = 0;
foreach (var student in students)
{
student.Courses = courses.Skip(index).ToList();
dbContext.Students.Add(student);
}
dbContext.SaveChanges();
dbContext.Dispose();
dbContext = new StudentsDbContext();
var homeworks = generator.GenerateHomeworks(5);
var actualStudents = dbContext.Students.ToList();
var actualCourses = dbContext.Courses.ToList();
var studentsToSkip = 0;
foreach (var homework in homeworks)
{
homework.Student = actualStudents.Skip(studentsToSkip).FirstOrDefault();
homework.Course = actualCourses.Skip(studentsToSkip).FirstOrDefault();
dbContext.Homeworks.Add(homework);
}
dbContext.SaveChanges();
}
public static void Main(string[] args)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentsDbContext, Configuration>());
var dbContext = new StudentsDbContext();
var studentNames = dbContext.Students.Select(s => s.Name).ToList();
}
public static void Main(string[] args)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentsDbContext, Configuration>());
var dbContext = new StudentsDbContext();
SeedData(dbContext);
var studentNames = dbContext.Students.Select(s => s.Name).ToList();
foreach (var studentName in studentNames)
{
Console.WriteLine(studentName);
}
}
static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentsDbContext, Configuration>());
var db = new StudentsDbContext();
var student = new Student()
{
Name = "Pesho"
};
db.Students.Add(student);
db.SaveChanges();
Console.WriteLine(db.Students.Count());
}
public HomeworksController()
{
this.db = new StudentsDbContext();
this.homeworks = new EfGenericRepository<Homework>(this.db);
}