Hi,
I have to implement one logic where I have a no. of fields and based on the values I am entering in these fields I have to show the search result in my view.ie, whatever values I am entering in these fields I need to search the db and retrieve records. I t is not mandatory to enter value for all the fields. At a time I may need to search entering value in 1 field or two or many or all. Any time I have to show result based on the entered values. Should I use a procedure or using Linq directly is efficient? how to write the query efficiently?