CodeProvider for SQL

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

 

[Miha Markic [MVP C#]]

Hi Adrian,

That, and a lot more, do ORMs.
For example, take a look at Paul Wilson's ORMapper at
http://www.ormapper.net/