public static void InsertQuestions(List <Question> questions) { using (var db = new QuizDBContext()) { db.Questions.AddRange(questions); db.SaveChanges(); } }
public static void InsertUsers(List <User> users) { using (var db = new QuizDBContext()) { db.Users.AddRange(users); db.SaveChanges(); } }
public static void InsertCategories(List <Category> categories) { using (var db = new QuizDBContext()) { db.Categories.AddRange(categories); db.SaveChanges(); } }
public static void DeleteAllData() { using (var db = new QuizDBContext()) { foreach (var usr in db.Users) { db.Users.Remove(usr); } foreach (var cat in db.Categories) { db.Categories.Remove(cat); } foreach (var question in db.Questions) { db.Questions.Remove(question); } foreach (var answer in db.Answers) { db.Answers.Remove(answer); } db.SaveChanges(); } }