public async Task GetById_ShouldReturnNull_WhenIdDoesNotExist()
    {
        // Arrange
        const int friendshipId = 21231;

        Friendship expectedFriendship = new() { FriendshipId = 1 };

        await _context.Friendships.AddAsync(expectedFriendship);

        await _context.SaveChangesAsync();

        IFriendshipRepository repository = new FriendshipRepository(_context);

        // Act
        Friendship friendship = await repository.GetByIdAsync(friendshipId);

        // Assert
        Assert.Null(friendship);
    }
    public async Task GetById_ShouldReturnFriendship_WhenIdMatches()
    {
        // Arrange
        const int friendshipId = 1;

        Friendship expectedFriendship = new() { FriendshipId = 1 };

        await _context.Friendships.AddAsync(expectedFriendship);

        await _context.SaveChangesAsync();

        IFriendshipRepository repository = new FriendshipRepository(_context);

        // Act
        Friendship friendship = await repository.GetByIdAsync(friendshipId);

        // Assert
        Assert.NotNull(friendship);
        Assert.Equal(friendshipId, friendship.FriendshipId);
    }