Connect4 SQL Designer provides developers with an advanced, yet simple to use End User Visual SQL Query Design Tool. It is a 100% .Net based component for implementation within your .Net applications. Use SQL Designer to add end user query design capability to your existing and new applications and empower your users to design their own queries from within your application.

SQL Designer uses database schema definitions that represent the data structures in your database. These schema definitions then support the creation, editing and saving of SQL Query definitions. You may create any number of schema definitions using the graphical interface tools provided with SQL Designer and persist those designs to XML definition files. SQL Designer also provides the UI components for schema building that you can place directly into your host application or, use our fully pre-built forms based interface.

With schemas created, you add a UI component into your host application to provide the interface for users to create and/or modify query designs (return sets, criteria, or both) based on schemas. Query designs, like schema designs are persisted to XML that may be handled by your application and stored in your database or at your option, loaded and saved directly on the file system.

Advanced functionality includes the ability to design queries to prompt users for time or context dependent query criteria and the ability to calculate and use dynamic conditions like 'is in last financial year', or, 'in last calendar quarter'.

The download includes a fully functional sample application and database.