public void GetSingleSovauser() { DateTime now = DateTime.Now; SovaUser retrievedSovaUser; SovaUser sovaUser = new SovaUser { SovaUserCreationDate = now }; var options = new DbContextOptionsBuilder <SovaContext>() .UseInMemoryDatabase(databaseName: "GetSingleSovauser") .Options; using (var context = new SovaContext(options)) { var service = new SovaUserDataService(context); service.Add(sovaUser); retrievedSovaUser = service.Get(1); } // 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.Equal(sovaUser.SovaUserCreationDate, context.SovaUsers.Single().SovaUserCreationDate); } }