Back to list
Views:   71.3K
Replies:  1

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: 

  • zero or more document types (any, company, personal, group, statement, invoice, etc).
  • filter by author last name (wild card) (i.e. LIKE  Smit%)
  • pagination support (page 2 with page size = 20)
  • order by filedate desc, author name asc.
So, in SQL I would implement this something like

   SELECT ROW_NUMBER() OVER (ORDER BY FileDate DESC, AuthorName ASC) AS RowNumber, *
     FROM  Document
    WHERE AuthorName LIKE 'Smit%'
) AS Results
But how does one build this dynamically in LINQ-to-SQL or LINQ-to-Entities?  The number of options are too numerous to build static LINQ queries for all possible combinations.

Craig Johnston, Feb 24, 2010
Reply 1
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

Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0