Project Description
SQLString 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.

Blog Site http://dotnet-jeff.blogspot.com/


Current Project Status
Version 1.0.0.1 - ALPHA (Design)


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:
    1. Default the generated statement into a standard variable or allow the user to define a variable.
    2. 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:
    1. Allow the user to insert the generated statement into the current IDE document at this.ApplicationObject.ActiveDocument.Object("TextDocument") as TextDocument;
    2. 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
STEP1.jpg



Step Two: Paste the SQL Statement into SQLString
STEP2.jpg


Step Three: Select Language, Data Type, Target Variable, and Width - Generate.
If satisfied, Press Insert
STEP3.jpg


Step Four: Check generated code, and insertion point.
STEP43.jpg

Last edited Jul 13, 2008 at 10:34 PM by JaDaar, version 21