public void InitializeDb()
 {
     var initializer = new DropCreateDatabaseIfModelChanges<SurveyorContext>();
       using (var db = new SurveyorContext())
       {
     initializer.InitializeDatabase(db);
     DbSeeder.Seed(db);
     db.SaveChanges();
       }
 }
        public void ResponsesContainsRespondent()
        {
            using (var db = new SurveyorContext())
              {
            var respondent = db.Respondents.First();
            var survey = db.Surveys.First();
            var response1 = new SurveyResponse() { RespondentId = respondent.Id, SurveyId = survey.Id };
            db.Responses.Add(response1);
            db.SaveChanges();
              }

              using (var db = new SurveyorContext())
              {
            var response = db.Responses.Include(r => r.Respondent).First();
            Assert.IsNotNull(response);
            Assert.IsNotNull(response.Respondent);
            Assert.IsNotNull(response.Respondent.UserName);
              }
        }