public async Task GetDrinksTestAsync() { var options = new DbContextOptionsBuilder <CoffeeDbContext>() .UseInMemoryDatabase(Guid.NewGuid().ToString()) .Options; using (var context = new CoffeeDbContext(options)) { var newDrink1 = new Drink { DrinkName = "test", Description = "test", Price = 100, CategoryId = 1, Category = new Category() }; var newDrink2 = new Drink { DrinkName = "test2", Description = "test2", Price = 200, CategoryId = 2, Category = new Category() }; var service = new DrinkRepository(context); await service.AddDrinkAsync(newDrink1); await service.AddDrinkAsync(newDrink2); } using (var context = new CoffeeDbContext(options)) { var service = new DrinkRepository(context); var result = service.GetDrinks(); Assert.AreEqual(2, result.Count()); } }