I tried to take only 1000 entities from about 7000. When Queryable converted to list, it is more then 1000 entities returned.
IQueryable<MyEntity> query = {some query};
query = query.Take(1000);
var cnt = query.Count(); // 1000
var list = query.ToList(); // 1217
var listId = query.Select(x => x.Id).ToList(); // 1000
How is it possible?
Query is simple enough, just like _context.MyEntities.Where();