public SQLDailyCheckInRepoTest()
        {
            optionsBuilder = new DbContextOptionsBuilder <ApplicationContext>();
            optionsBuilder.UseInMemoryDatabase("UnitTestInMemoDB2");
            dbContext = new ApplicationContext(optionsBuilder.Options);

            _checkInRepo = new SQLDailyCheckInRepo(dbContext);
        }
 public void Dispose()
 {
     optionsBuilder = null;
     foreach (var checkIn in dbContext.DailyCheckIns)
     {
         dbContext.DailyCheckIns.Remove(checkIn);
     }
     dbContext.SaveChanges();
     dbContext.Dispose();
     _checkInRepo = null;
 }