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
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...