public async Task AllForAPeriodWithValidId() { ApplicationDbContext dbContext = new ApplicationDbContext(new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(databaseName: Guid.NewGuid().ToString()).Options); var machineContersService = new MachineCountersService(new EfRepository <MachineCounters>(dbContext)); var service = new ReportService(new EfDeletableEntityRepository <Report>(dbContext), machineContersService); var data1 = DateTime.UtcNow; for (int i = 1; i <= 5; i++) { await service.AddAsync(data1, 1, 1, "1"); } var data2 = DateTime.UtcNow; var reports = service.AllForAPeriod <IndexReportViewModel>("1", data1, data2); int count = 0; foreach (var report in reports) { count++; } Assert.Equal(5, count); dbContext.Database.EnsureDeleted(); }