I found a quite specific case, when
Where().OrderBy().Take().Any()
does not work as expected, while Where().OrderBy().Take().AsEnumerable().Any()
gives the correct result. Find below the code example:

var repository = new MongoRepository();

var id = new Guid("08d12048-7851-bc17-259f-9b16589f0d15");
const string Username = "testu";
var queryable = repository.database.GetCollection<Machine>("machine").AsQueryable();
var userMachines = queryable.Where(m => m.Username == Username).OrderBy(m => m.CreatedOn);
var mustBeTrue = userMachines.Take(3).Any(m => m.Id == id) == userMachines.Take(3).AsEnumerable().Any(m => m.Id == id);
Console.WriteLine(mustBeTrue)
-------
Prints "False". repository.database is of type MongoDatabase. CreatedOn is DateTime.