// Method 1

public PartialViewResult feeds(int page)
    {
        // if page=1 then 10 records if page=2 then 20 records etc.
        const int recordsPerPage = 10;
        var skipRecords = page * recordsPerPage;
var iefeedss = sqlConnection.Query<thread>("Select * From (SELECT ROW_NUMBER() OVER (order   by ...) AS Row,* FROM threads where
.. statement) As threads where Row >= 1 AND Row <=@lower", new {lower = skipRecords }).ToList();

                  }
// Method 2

public PartialViewResult feeds(int page)
    {
         // if page=1 then 10 records if page=2 then 20 records etc.
        const int recordsPerPage = 10;
        var skipRecords = page * recordsPerPage;
 var iefeedss = sqlConnection.Query<thread>("Select top @lower * From my table", new  {lower=skipRecords }).ToList();

             }