I am trying Dapper ORM and I am querying a a Posts table.
But I would like to get paged results ...
1 - How can I do this? Isn't there a helper for this?
2 - Can Dapper Query return an IQueryable?
Thank You, Miguel
1) Dapper doesn't have a built-in pagination feature. But its not too hard to implement it directly in the query. Example:
SELECT *
FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY InsertDate) AS RowNum, *
FROM Posts
WHERE InsertDate >= '1900-01-01'
) AS result
WHERE RowNum >= 1 // *your pagination parameters
AND RowNum < 20 //*
ORDER BY RowNum
Requires SQL Server 2005+
2) Dapper returns an IEnumerable<T>
.