I have a page that gives the user the ability to generate a report based on the selected filters. I need some suggestion or thought about my thoughts.
Loop through each filter (check box, multi-position list, list of radio boxes) and build dynamic where are the conditions and conjunctions for each filter, and then run the query
Get all the data (I think it will cause an overload with all 4-5 tables), and then use Linq to filter this data based on user selection
Is there a better way to implement this?
source
share