Guys, I have an application in .Net where I need to search a query based on what the user chooses on dropdowns. There are 8 choices, A user can choose to select one, or even all of them, and get the records based on the selection. If I Use if conditions then I would end up with quite a number of IFs which I think is not Ideal, What do you guys recommend?