I have a custom application where the user can select multiple (13) parameters to select data from a SharePoint list. To achieve this, I want to use LINQ to query this data from SharePoint.
The enduser can select from different dropdowns to filter. I need to build a dynamic query for these "filters".
I know how to achieve this by CAML but due to the large amount of filters, its highly complicated to build a CAML with possible 13 AND's.
I want to use LINQ to SharePoint but you are not able to create dynamic WHERE clauses.
Is it possible to create dynamic WHERE clauses and if yes how?