Is there a fast way to get rows from a table by range as IQueryable in C# LINQ to SQL?

Question

like say I want to make a method in my repository like

public IQueryable<Item> GetAllItemsByRange(int start, int end)

and then I just want to pass like (1, 100), (101, 200), (201, 300), etc so I can get back ONLY that range without having to get EVERYTHING at once

thanks!

Answer 1

queryable.Skip(start - 1).Take(end - start + 1)

Answer 2

return (from t in table select t).Skip(start).Take(end - start);

Answer 3

orderby is the key, then you can use skip(100).take(100) to do the rest.