Task Number : 005
Task Name : SQL Parsing Tools
Task Type : Research Task.
Task Budget : $100
Time Frame : OPEN – due when completed
This is an initial DRAFT TASK SPECIFICATION.
The specification may change.
Find all available products or software packages that can parse SQL statements for the .NET environment.
The preferred language is VB.NET, but C# is acceptable too.
Make a list of these products.
Grade these products in terms of their suitability for our SSS and [url removed, login to view] applications: e.g. dynamic sql generation, syntax checking, semantics checking, etc.
For the most promising products or packages, develop a small set of tests, and try them out.
Write a brief report summarizing these findings.
(As you are doing your research, you may want to take a look at how SSS uses the sql_routines to build and manage queries. We will want to integrate the SQL parsing and analysis tools that you find into sql_routines – I THINK [I’m not entirely sure, but that would seem reasonable])