public void GetUsersFavoriteSongs() { var options = new DbContextOptionsBuilder <ApplicationDbContext>() .UseInMemoryDatabase(databaseName: "InHarmonyTestControllerDB") .Options; using (var context = new ApplicationDbContext(options)) { context.Database.EnsureDeleted(); context.Database.EnsureCreated(); Repository repository = new Repository(context, _repositoryLogger); BusinessLogicClass logic = new BusinessLogicClass(repository, _mapperClass, _repositoryLogger); SongController songController = new SongController(logic, _songControllerLogger); // create a user var user = new User(); // create a song var song = new Song(); repository.songs.Add(song); repository.users.Add(user); // create a favorite var fave = new FavoriteList { UserId = user.Id, SongId = song.Id }; repository.favoriteLists.Add(fave); context.SaveChanges(); var s = songController.GetUsersFavoriteSongs(user.Id); Assert.NotEmpty(s.Result); } }