С# LINQ IQueryable Take

172 Views Asked by At

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();

0

There are 0 best solutions below