public static void AddStudent() { using (var context = new EFExampleBasicContext()) { var someClassId = context.Classes .Where(studyClass => studyClass.Name == "TA-81") .Select(studyClass => studyClass.Id) .FirstOrDefault(); var newStudent = new Student() { FirstName = "Anufriy", LastName = "Korch", Address = new Address() { City = "Kiev", FirstLine = "Troeshina", SecondLine = "Amin'" }, StudyClassId = someClassId }; context.Students.Add(newStudent); context.SaveChanges(); } }
public static void ModifyStudent() { using (var context = new EFExampleBasicContext()) { var firstStudent = context.Students.FirstOrDefault(); firstStudent.FirstName = "modifiedName"; var entry = context.Entry(firstStudent); context.SaveChanges(); } }
public static void AddStudyClass() { using (var context = new EFExampleBasicContext()) { var newClass = new StudyClass() { Name = "TA-81", StartYear = 2017, }; context.Classes.Add(newClass); context.SaveChanges(); } }
public static void ShowAllClassesAndStudents() { using (var context = new EFExampleBasicContext()) { var classes = context.Classes.ToList(); foreach (var studyClass in classes) { var studentsCount = studyClass.Students.Count; Console.WriteLine("Class {0} has {1} students", studyClass.Name, studentsCount); foreach (var student in studyClass.Students) { Console.WriteLine("Student {0} {1}. From {2}, {3}, {4}. Born {5}", student.FirstName, student.LastName, student.Address.City, student.Address.FirstLine, student.Address.SecondLine, student.DateOfBirth ?? "somewhen"); } } } }