I am looking for a wizard based tool that allows the end user to automate the process of building datasource specific sql statements. it should use the data link dialog box as the first screen to connect to a datasource then each screen in turn will allow the user to build a statement i.e a. select table from datasource b. select option (select/insert/update/delete) c. select field(s) to perform operation on i.e select field1, field2 from table d. select fields for where clause e. enter scalar values for item c and d based on field datatype i.e insert into table (field1,field2) values ("value1", false) where field3=value3 f. enter operators for item d i.e where field1=x AND field2=y OR field3=z. Once this is done an SQL statement specific to the datasource should be generated
I am looking to support MySQL, SQL Server, Oracle and Access.
The application needs to be written in C# and store all of the above information in a SQL Express DB. it is important that it is wozard based i.e the user can move backwards and forwards throught the process and all options should be persistently displayed. caching of some sort would be nice. when the user gets to the end of the process they can select to continue to build another statement on the same datasource or connect to another.