For developers: Filter pages using LINQ queries

Sitefinity CMS supports dynamic LINQ queries that can execute lambda expressions defined in a string against an IQueryable collection. This article demonstrated how to filter monolingual and multilingual pages using two different methods: pages.Where() and DataProviderBase.SetExpressions().

To filter a collection of pages by their title, perform the following:

1. Use the PageManager class to get all pages under the root node of your site.
2. Construct the string used to filter those pages by their title.
3. Filter the page collection by passing the constructed string filter to the Where() method.

To filter pages with the pages.Where() method, use the following code snippet:

NOTE: To execute dynamic LINQ queries, in your code, you must add using Telerik.Sitefinity.Data.Linq.Dynamic;

Filter multilingual pages with the pages.Where() method

If you have multilingual pages, to ensure the filter you pass is executed against the Lstring value for the correct culture you can use the following code sample:

1. Use the PageManager class to get all pages under the root node of your site.
2. Set the desired thread culture.
3. Construct the string used to filter those pages by their title.
4. Filter the page collection by passing the constructed string filter to the Where() method.
5. Set the original thread culture.

To filter multilingual pages with the pages.Where() method, use the following code snippet:

1. Use the PageManager class to get all pages under the root node of your site.
2. Construct the string used to filter those pages by their title.
3. Filter the page collection by calling the DataProviderBase.SetExpressions() method and passing the following parameters:
   • filterExpression
   • sortExpression
   • skip
   • take
   • totalCount

To filter pages with the DataProviderBase.SetExpressions() method, use the following code snippet:

NOTE: To use the DataProviderBase class, in your code, you must add using Telerik.Sitefinity.Data;