public void mockExamDataIntoDB() { ExamsController ExamsController = new ExamsController(); UseSqlite(); using (var context = GetDBContext()) { Accounts SelectedAccount = context.Account .Where(a => a.Status == "STUDENT") .Select(a => a).Single(); Course SelectedCourse = context.Course .Include(c => c.ClosedQuestionsList) .Include(q => q.OpenedQuestionsList) .Where(course => course.CourseType == "Architecure .NET") .Select(seleceteCourse => seleceteCourse).Single(); var CQuestions = context.ClosedQuestions.Where(questions => questions.Course.CourseType.Equals("Architecure .NET")) .Select(questions => questions).ToList().Take(4); var OQuestions = context.OpenedQuestions.Where(questions => questions.Course.CourseType.Equals("Architecure .NET")) .Select(questions => questions).ToList().Take(4); var ExamCQuestions = ExamsController.CreateExamClosedQuestions(CQuestions.ToList()); var ExamOQuestions = ExamsController.CreateExamOpenedQuestions(OQuestions.ToList()); Exams exam = new Exams() { AmountClosedQuestions = CQuestions.Count(), AmountOpenedQuestions = OQuestions.Count(), ExamTimeInMinute = 30, DateOfExam = DateTime.Now, ExamClosedQuestions = ExamCQuestions, ExamOpenedQuestions = ExamOQuestions, CourseID = SelectedCourse.CourseID, AccountID = SelectedAccount.AccountsID, ExamResult = new Results() }; ExamCQuestions.ForEach(x => exam.ExamResult.MaxExamPoints += 1); ExamOQuestions.ForEach(x => exam.ExamResult.MaxExamPoints += x.OpenedQuestions.MaxPoints); context.Exams.Add(exam); context.SaveChanges(); }; }