Closed

Multi Database SQL Statement

This project received 9 bids from talented freelancers with an average bid price of ₹22822 INR.

Get free quotes for a project like this
Employer working
Project Budget
₹1500 - ₹4000 INR
Total Bids
9
Project Description

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online