Why does LINQ-to-SQL Paging fail inside a function?
- by ssg
Here I have an arbitrary IEnumerable<T>. And I'd like to page it using a generic helper function instead of writing Skip/Take pairs every time. Here is my function:
IEnumerable<T> GetPagedResults<T>(IEnumerable<T> query, int pageIndex, int pageSize)
{
return query.Skip((pageIndex - 1) * pageSize).Take(pageSize);
}
And my code is:
result = GetPagedResults(query, 1, 10).ToList();
This produces a SELECT statement without TOP 10 keyword. But this code below produces the SELECT with it:
result = query.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
What am I doing wrong in the function?
