I am curious how I can go about doing the following. I am creating an application that is similar to the custome data filter on excel. Here is an example of how the custom data filter would work:
If (Column A) "is greater than" 0
If (Column B) "is greater than" 0
A similar query in LINQ would look like:
var query = from s in CurrentDataContext.TableA
where (s.ColumnA > 0) && (s.ColumnB > 0)
The problem I am having is that the user is more or less setting its own rules, with an infanite number of conditions. Therefore, I cannot set a query for each possible query. I need to somehow use loops or just in general make it flexible enough to be able to do this.
Does anyone know how I can do that? If I need to elaborate, please let me know.