Dynamic LINQ solution?
In our app we have a situation where the users can select from numerous criteria and get back a subset of a large number of documents. Also, supported are pagination and sort order. Criteria may include:
SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY FileDate DESC, AuthorName ASC) AS RowNumber, * FROM Document WHERE AuthorName LIKE 'Smit%' ) AS Results WHERE RowNumber BETWEEN 20 AND 40
Craig Johnston, Feb 24, 2010
here is a good tutorial by Scott. Look at the Skip() and Take() methods.
here is a sample too (its VB so its probably wrong :))
Aaron Burton, Feb 26, 2010