Hi @Simone_Restani, as Kanika mentioned above, you can skip the .Sort method. Please refer to the code below and hopefully, it will work as expected.
return await _moviesCollection.Aggregate() .Match(Builders<Movie>.Filter.Eq(x => x.Id, movieId)) // Ticket: Get Comments // Add a lookup stage that includes the // comments associated with the retrieved movie .Lookup( _commentsCollection, m => m.Id, c => c.MovieId, (Movie mov) => mov.Comments ) .FirstOrDefaultAsync(cancellationToken);
I hope it helps.
In case you have any doubts, please feel free to reach out to us.
Thanks and Regards.
Curriculum Services Engineer