I have used MyGeneration and found it an ideal and extremely flexible template based code generator. It is free software written in Microsoft.NET.

MyGeneration generates code from templates. These templates can be written in C#, VB.NET, JScript, and VBScript. MyGeneration is for generating ORM architectures or O/R Mapping files for architectures such as Gentle.NET, and NHibernate. The meta-data from your database is made available to your templates through the MyMeta API.

MyGeneration can generate code for non-Microsoft operating systems. It supports MySQL, PostgreSQL, Microsoft SQL, Oracle, IBM DB2, Microsoft Access, FireBird, Interbase, SQLite, VistaDB and Advantage.

MyGeneration installs with many sample templates that generate C# and VB.NET code, Stored Procedures, PHP, and HTML. Adapt existing templates or write your own to generate your particular architecture.

MyGeneration also offers its own .NET architecture known as dOOdads, it's available in C# and VB.NET.

MyGeneration Version 1.3.0.3 fixes MySQL, Firebird, SQLite issues.

 Free Download   MyGeneration 1.3.0.3