public void CanPromoteBookRanking() { var options = new DbContextOptionsBuilder <ReadingListApiContext>() .UseInMemoryDatabase("can_promote_book_ranking") .Options; using (var context = new ReadingListApiContext(options)) { ReadingList readingList = new ReadingListFixture().ReadingList(); context.Add(readingList); context.SaveChanges(); Book book1 = readingList.Books[0]; Book book2 = readingList.Books[1]; Book book3 = readingList.Books[2]; readingList.UpdateRankings(book3.BookId, 2); Assert.Equal(1, book1.Ranking); Assert.Equal(3, book2.Ranking); Assert.Equal(2, book3.Ranking); } }