Views: 84.1K
Replies: 1
Archived
|
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 Thanks. Craig Johnston, Feb 24, 2010
|
|
Reply 1here is a good tutorial by Scott. Look at the Skip() and Take() methods.
http://weblogs.asp.net/scottgu/archive/2007/06/29/linq-to-sql-part-3-querying-our-database.aspx here is a sample too (its VB so its probably wrong :)) http://stackoverflow.com/questions/770909/linq-over-datatable-with-skip-and-take-method Aaron Burton, Feb 26, 2010
|