https://bryanavery.co.uk/linq-to-sql-and-paging/?utm_source=rss&utm_medium=rss&utm_campaign=linq-to-sql-and-paging this and that Wed, 17 Dec 2008 20:02:17 +0000 hourly 1 https://wordpress.org/?v=6.9.4 https://bryanavery.co.uk/linq-to-sql-and-paging/#comment-24 Wed, 17 Dec 2008 20:02:17 +0000 /post/2008/12/15/LINQ-to-SQL-and-Paging/#comment-24 Keep in mind that you have to apply an "order by" to ensure that the rows you are retrieving are in a predictable order. Additionally, linq2sql will make different queries for the first page (uses top N) and consecutive pages (uses rownumber) which can cause missed rows if your "order by" does not contain the primary key of the row.

]]>