CodeProvider for SQL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The .NET framework includes CodeProviders for C# and other languages to
simplify generating source code.

Does anyone know of a product or open source project that provides the same
concept, but for the SQL language. Given the vast number of databases out
there, it makes sense to me to create a set of interfaces or classes for
generating the various SQL statements and then writing a code provider for
each target database.

For example,
SQLCodeGenerator
Handles rules and types common to all DDL statements
GenerateCastExpression
GenerateCaseFunction
GenerateComment
....

SQLSelectCodeGenerator derived from SQLCodeGenerate
Handles generating a valid SELECT statement for the target database.
GenerateTop
GenerateColumn
GenerateInfo
GenerateFrom
....

Does this make sense? Is it a good idea?

Ad.
 
Back
Top