I'm working on a Windows Forms based C# application, that manages a SQL database with results of scientific experiments. This database consists of about 100 Tables, some of them fairly complex.
The user should be able to conduct complex searches by defining search filters in a form and specifying what type of object he is looking for, and which values should meet certain criteria (see attached screenshot). The attributes in the filters can come from different tables, and can be Strings or numbers.
How can I accomplish this functionality? Shall I use Stored Procedures on the SQL-Server level, or search through the DataSet in C#? Perhaps someone could point me in the right direction.
Thanks for any help