You can also use Linq-to-SQL for that. It is a case where it is much simpler to express the query in Linq.
var query =
from m in dataContext.MyTable
select m;
var result = query.Skip(100).Take(100);
Or even if you don't use it, you might get
LINQPad[
^], write a Linq query and then get the generated SQL code...