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.
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.