title: Cassandra pagination with c#
body: <p>when I do pagination for MS SQL Server to be used with jquery datatable I write a simple sp like this</p>
  
  <pre><code>create PROCEDURE [dbo].[Get_SomeData] (
  @startRowIndex BIGINT, @maximumRows BIGINT ,@sSearch VARCHAR(MAX),@total INT OUTPUT
  ) 
  AS 
  
  
  DECLARE @temp TABLE(RowRank BIGINT,custid BIGINT,names VARCHAR(500))
  
  INSERT INTO @temp
     SELECT ROW_NUMBER() OVER (ORDER BY custid) AS 
    RowRank,custid,names FROM dbo.SomeTable WHERE   (names LIKE '%'+@sSearch+'%'   )
  
     SELECT @total=COUNT(custid) FROM @temp
  
   SELECT *  FROM @temp  WHERE  RowRank &gt; @startRowIndex 
   AND RowRank &lt;= (@startRowIndex + @maximumRows)
  </code></pre>
  
  <p>This makes it easy to page through the data by incrementing @startRowIndex. But how to achieve the same pagination thing with a Cassandra database and a c# client like  fluentcassandra (or any c# client library)</p>