static void Delete(UniversityEntities context) { Console.WriteLine("===>> Enter name to delete"); string name = Console.ReadLine(); context.Student.Remove(context.Student.FirstOrDefault(x => x.Name == name)); context.SaveChanges(); }
static void Update(UniversityEntities context) { Console.WriteLine("===>> Enter ID group for update :"); string group = Console.ReadLine(); Student st = context.Student.FirstOrDefault(x => x.Name == "Alina"); st.Groups.Name = group; context.SaveChanges(); }
private static void Add(UniversityEntities context) { Student st = new Student { Name = "Olia", Surname = "Olia", Groups = context.Groups.First() }; //Student st = new Student { Name = "Olia", Surname = "Olia", Groups = new Groups { Name = "Step" } }; context.Student.Add(st); context.SaveChanges(); }
private static void ChangeSurname(UniversityEntities context) { var minMark = context.Achievement.Where(x => x.Subject.Name == "C#").Min(x => x.Mark); int?studID = context.Achievement.Where(x => x.Mark == minMark && x.Subject.Name == "C#").Select(x => x.IdStudent).SingleOrDefault(); foreach (var item in context.Student.Where(x => x.Id == studID)) { Console.WriteLine($"{item.Name} {item.Surname}"); } Console.WriteLine("===>> Enter Surname to update :"); string surname = Console.ReadLine(); Student st = context.Student.Where(x => x.Id == studID).FirstOrDefault(); st.Surname = surname; context.SaveChanges(); Print(context); }