I have a dropdownlist for search field, and a text box for search value. User can search by selecting a search field from dropdownlist and type in the textbox.
SELECT * FROM Customer WHERE @SearchField LIKE @SearchValue
I would not know the name of the column in design time. I have tried to do the same feature using ExecuteQuery<Customer >(query), but I don't really like it.
How can I write that kind select statement in LINQ (Example, Customer.where(c => c....) . Thank you for your comments!