public static void Main(string[] args)
{
Database.SetInitializer <StudentsSystemContext>(null);
Database.SetInitializer(new MigrateDatabaseToLatestVersion <StudentsSystemContext, Configuration>());
var db = new StudentsSystemContext();
Student pesho = new Student();
Course php = new Course();
pesho.Course.Add(php);
pesho.FacultyNumber = "FN0001";
pesho.Name = "Pesho";
db.Students.Add(pesho);
php.Description = "PHP";
php.Materials = "No materials";
php.Student.Add(pesho);
db.Courses.Add(php);
foreach (var cours in db.Courses)
{
System.Console.WriteLine(cours.Student.Count);
}
db.SaveChanges();
}
static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<StudentsSystemContext, Configuration>());
StudentsSystemContext studentSystemDb = new StudentsSystemContext();
foreach (var item in studentSystemDb.Students)
{
Console.WriteLine("Name: {0} , Student Number: {1}", item.StudentName + ' ' + item.StudentLastName, item.StudentNumber);
}
studentSystemDb.SaveChanges();
}
public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <StudentsSystemContext, Configuration>());
using (var db = new StudentsSystemContext())
{
Console.WriteLine("********************** Students ************************");
foreach (var student in db.Students)
{
Console.WriteLine("ID: {0}; Name: {1}; Student number: {2}", student.Id, student.Name, student.Number);
}
Console.WriteLine("********************** Courses *************************");
foreach (var course in db.Courses)
{
Console.WriteLine("ID: {0}; Name: {1}; Description: {2}; Materials: {3}", course.Id, course.Name, course.Description, course.Materials);
}
}
}
public static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <StudentsSystemContext, Configuration>());
using (var db = new StudentsSystemContext())
{
Console.WriteLine("Students:");
foreach (var student in db.Students)
{
Console.WriteLine(student.Id + ": " + student.Name + " has number " + student.Number);
}
Console.WriteLine("Courses:");
foreach (var course in db.Courses)
{
Console.WriteLine(course.Id + ": " + course.Name + " has description " +
course.Description + " and needs materials: " + course.Materials);
}
}
}
public StudentsController(StudentsSystemContext context)
{
_context = context;
}
