static void DoOneToMany(AvansContext db, string forPerson) { Random random = new Random(); Grade grade = new Grade { GradeName = $"Prog {random.Next(1, 4)}", Result = random.Next(0, 10) }; var person = db.People.First(x => x.Firstname.ToLower() == forPerson); person.Grades.Add(grade); db.SaveChanges(); }
static bool DoManyToMany(AvansContext db, string forPerson) { Random random = new Random(); int id = random.Next(1, 3); var person = db.People.Include(x => x.Workshops).First(x => x.Firstname.ToLower() == forPerson); var ws = db.Workshops.FirstOrDefault(x => x.Id == id); if (ws != null) { if (!person.Workshops.Any(x => x.Id == ws.Id)) { person.Workshops.Add(ws); return(db.SaveChanges() > 1); } } return(false); }