static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <StudentsSystemDbContext, StudentsSystemConfiguration>());
var db = new StudentsSystemDbContext();
db.Courses.Count();
}
private static void AddCourses(int coursesCount)
{
//// It's no good if count > 100
using (var dbContext = new StudentsSystemDbContext())
{
for (int i = 0; i < coursesCount; i++)
{
var course = new Course();
course.Name = RandomDataGenerator.GetString(2, 50);
dbContext.Courses.Add(course);
}
dbContext.SaveChanges();
}
}
public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <StudentsSystemDbContext, Configuration>());
using (var db = new StudentsSystemDbContext())
{
DataCreator builder = new StudentsSystemDataCreator(db);
DataImporter dataImporter = new StudentsSystemDataImporter(builder);
dataImporter.ImportData();
}
using (var db = new StudentsSystemDbContext())
{
var studentsWithCoursesAndHomework = db.Students
.Select(s => new
{
StudentName = s.Name,
CoursesCount = s.Courses.Count,
HomeworkCount = s.Homeworks.Count
})
.ToList();
Console.WriteLine("Students with courses and homework:");
foreach (var student in studentsWithCoursesAndHomework)
{
Console.WriteLine("========================================");
Console.WriteLine(
"Student: {0}\nCourses count: {1}\nHomework count: {2}",
student.StudentName,
student.CoursesCount,
student.HomeworkCount);
Console.WriteLine("========================================");
}
}
}
private static void AddStudents(int studentsCount)
{
var dbContext = new StudentsSystemDbContext();
for (int i = 0; i < studentsCount; i++)
{
var student = new Student();
student.FirstName = RandomDataGenerator.GetString(2, 10);
student.LastName = RandomDataGenerator.GetString(2, 15);
student.FacultyNumber = RandomDataGenerator.GetString(10, 10);
dbContext.Students.Add(student);
if (i % 100 == 0)
{
dbContext.SaveChanges();
dbContext.Dispose();
dbContext = new StudentsSystemDbContext();
}
}
dbContext.SaveChanges();
}
private static void AddHomeworks(int homeworksCount)
{
var dbContext = new StudentsSystemDbContext();
var coursesIds = dbContext.Courses
.Select(c => c.Id)
.ToList();
int coursesIdsCount = coursesIds.Count;
var studentsIds = dbContext.Students
.Select(st => st.Id)
.ToList();
for (int i = 0; i < homeworksCount; i++)
{
var hw = new Homework();
hw.Content = RandomDataGenerator.GetString(1, 500);
int courseIndex = RandomDataGenerator.GetInteger(0, coursesIdsCount - 1);
hw.CourseId = coursesIds[courseIndex];
// works while students count is equal or greater than homeworks count
hw.StudentId = studentsIds[i];
dbContext.Homeworks.Add(hw);
if (i % 100 == 0)
{
dbContext.SaveChanges();
dbContext.Dispose();
dbContext = new StudentsSystemDbContext();
}
}
dbContext.SaveChanges();
}
static void Main()
{
// Create new student system
var context = new StudentsSystemDbContext();
// Create C# course
var cShardCourse = new Course
{
Name = "C#",
Description = ".NET technology"
};
context.Courses.Add(cShardCourse);
context.SaveChanges();
// Create student
var student = new Student
{
Name = "Pesho",
Number = 123,
};
// Register student to C# course
student.Courses.Add(cShardCourse);
context.Students.Add(student);
context.SaveChanges();
// Create homework
context.Homeworks.Add(new Homework
{
Content = "What database models do you know?",
TimeSent = new DateTime(2015, 09, 20),
CourseId = 1,
StudentId = 1
});
context.SaveChanges();
}
public GenericRepository(StudentsSystemDbContext context)
{
this.Context = context;
this.DbSet = this.Context.Set <T>();
}
static void Main(string[] args)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <StudentsSystemDbContext, Configuration>());
var db = new StudentsSystemDbContext();
db.Students.Add(new Students
{
Name = "Georgi",
PhoneNumber = "089712345",
RegistrationDate = new DateTime(2015, 01, 02),
Birthday = new DateTime(2015, 10, 02)
});
db.SaveChanges();
db.Courses.Add(new Courses
{
Name = "Uvod v C#",
Description = "Za nachinaeshti",
StartDate = new DateTime(2015, 01, 23),
EndDate = new DateTime(2015, 04, 23),
Price = 100
});
db.SaveChanges();
db.Courses.Add(new Courses
{
Name = "Uvod v C++",
Description = "Za nachinaeshti",
StartDate = new DateTime(2015, 01, 23),
EndDate = new DateTime(2015, 04, 23),
Price = 150
});
db.SaveChanges();
db.Courses.Add(new Courses
{
Name = "Uvod v JavaScript",
Description = "Za nachinaeshti",
StartDate = new DateTime(2015, 01, 23),
EndDate = new DateTime(2015, 04, 23),
Price = 200
});
db.SaveChanges();
db.Homeworks.Add(new Homework
{
Content = "homework nomer 1",
HomeworkContentType = ContentType.application,
DateAndTime = new DateTime(2015, 01, 02),
StudentId = 1,
CoursesId = 2
});
db.SaveChanges();
db.Homeworks.Add(new Homework
{
Content = "homework nomer 2",
HomeworkContentType = ContentType.pdfOrApplication,
DateAndTime = new DateTime(2015, 04, 02),
StudentId = 2,
CoursesId = 2
});
db.Homeworks.Add(new Homework
{
Content = "homework nomer 3",
HomeworkContentType = ContentType.zip,
DateAndTime = new DateTime(2015, 01, 23),
StudentId = 3,
CoursesId = 3
});
db.SaveChanges();
db.Resources.Add(new Resources
{
Name = "knigi za programirane",
Resource = TypeOfResource.other,
Link = "wwww.azSiZnamVsichko.com"
});
db.SaveChanges();
db.Resources.Add(new Resources
{
Name = "interner",
Resource = TypeOfResource.document,
Link = "wwww.azSiZnamVsichko.com"
});
db.SaveChanges();
}
public DataCreator(StudentsSystemDbContext db)
{
this.Database = db;
}
public static void Initialize()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <StudentsSystemDbContext, StudentsSystemConfiguration>());
StudentsSystemDbContext.Create().Database.Initialize(true);
}
public StudentsSystemDataCreator(StudentsSystemDbContext db)
: base(db)
{
}
public StudentRepository(StudentsSystemDbContext context)
: base(context)
{
}
