Project DescriptionSQLString is an AddIn for MS Visual Studio 2005 which will generate (C#, C, C++, VB, Java [to be changed to J#]) compatible source code from a SQL statement.
Functional Requirements:
- Allow the user to either paste or have linked into the control a specific SQL statement.
- Select a target language and based on the language chosen, allow the user to select from a pre-defined list of data types compatible with the selected language.
- Enable the user to select both a template (customizaable).
- Generate a source code statement which is compatible with the selected language. User parameters related to code generation:
- Default the generated statement into a standard variable or allow the user to define a variable.
- Define the "wrap" point for the characters in the generated statement. Default is 80, which currently means if a WORD will cause the generated string to exceed that parameter it will be wrapped to the next line.
- Enable the generated SQL statement to be:
- Allow the user to insert the generated statement into the current IDE document at this.ApplicationObject.ActiveDocument.Object("TextDocument") as TextDocument;
- Enable the user to save the results into both the CODEKeep Library and XML Files.
CODEKeep Library
- Enables the storage of all source SQL and target souce code generated. It can be associated with a Project or not. (This is on issues list)
- One library entry may have multiple code entries, versions etc.
- The user can add, retrieve, update, delete from the CODEKeep while in the main dialog.
| IDE Requirements |
|---|
| Microsoft Visual Studio 2005. Version 8.0.50727.762 (SP.050727-7600) .NET 2.0.50727 SP1 |
| Minimal Database Requirements |
|---|
| Microsoft SQL Server 2000 - 8.00.194 (Intel X86) |
| NOTE: | I see no reason why SQL Server Express 2005 or SQL Server 2005/2008 will not also work, it simply has not been tested so far. |
| NOTE: | Next revision will support Access. |
Screenshots of Version 1.0.0.1| Step One: | Create SQL Statement in some tool |
|---|
| For this I did it in Query Analyzer |
 |
| Step Two: | Paste the SQL Statement into SQLString |
|---|
| |
 |
| Step Three: | Select Language, Data Type, Target Variable, and Width - Generate. |
|---|
| If satisfied, Press Insert |
 |
| Step Four: | Check generated code, and insertion point. |
|---|
| |
 |