public void GetListOfSovaUsers() { DateTime now = DateTime.Now; int AmountOfRetrievedSovaUsers = 5; IList <SovaUser> retrievedSovaUser; SovaUser sovaUser = new SovaUser { SovaUserCreationDate = now }; var options = new DbContextOptionsBuilder <SovaContext>() .UseInMemoryDatabase(databaseName: "GetListOfSovausers") .Options; using (var context = new SovaContext(options)) { var service = new SovaUserDataService(context); service.Add(sovaUser); now = DateTime.Now; service.Add(sovaUser); now = DateTime.Now; service.Add(sovaUser); now = DateTime.Now; service.Add(sovaUser); now = DateTime.Now; service.Add(sovaUser); retrievedSovaUser = service.GetList(0, AmountOfRetrievedSovaUsers); } // Use a separate instance of the context to verify correct data was saved to database using (var context = new SovaContext(options)) { Assert.NotNull(retrievedSovaUser); Assert.NotEmpty(retrievedSovaUser); Assert.IsType <List <SovaUser> >(retrievedSovaUser); Assert.Equal(AmountOfRetrievedSovaUsers, retrievedSovaUser.Count()); } }