public void UpdateQuestion(Question updateQuestion) { using (var db = new QuizModel()) { //attach question object to the object in the db. db.Questions.Attach(updateQuestion); var entry = db.Entry(updateQuestion); //the Modified indicates and update entry.State = System.Data.Entity.EntityState.Modified; foreach (var answer in updateQuestion.Answers) { var answerEntry = db.Entry(answer); answerEntry.State = System.Data.Entity.EntityState.Modified; } db.SaveChanges(); } }
public Question GetQuestionById(int id) { using (var db = new QuizModel()) { //This will hand back the question and the collection of answers; load them pls. var question = db.Questions.Find(id); db.Entry(question).Collection(q => q.Answers).Load(); return(question); } }