Does "Count ()" after "Take ()" on "IQueryable" return an incorrect result?

Question

After executing the take(n)linq method on the IQueriable data (initial counter m), the method Count()still returns a value m.

Does the command ToList()execute the only option to get the actual score from IQueryable?

var data = service.Get();//100 records
var data2 = data.Take(10);

var count = data2.count(); //result 100 - wrong
var count2 = data2.ToList().Count; // result 10 - correct

Answer 1

You should use ToList () for this case or find an alternative solution or limit the result of Count () yourself (since the correct value can never be greater than the value specified for Take ()).

NHibernate: https://nhibernate.jira.com/browse/NH-2477