title: Data paging in SQL Server CE (Compact Edition)
body: <p>I am writing a wpf destop application, and would like to use SQL Server CE as a backend.  I'm trying to come up with a good way to do efficient data paging.  In SQL Server Express, I can do something like this: </p>
  
  <pre><code>Select ID, FirstName, LastName
  From (SELECT  ROW_NUMBER() OVER (ORDER BY ID)
   AS Row, ID, FirstName, LastName
   From TestTable                             
  ) 
  WHERE  Row &gt; 1 AND Row &lt;= 10    
  </code></pre>
  
  <p>Is there anything comparable in SQL Server CE?  I'm not completely sure what is and is not supported.  I want to only return 10 rows at a time from the database, and not have to pull back all the data and then filter it down to display to the user, since that is much slower.  Thanks.</p>