Lattice.SPGen is a template-based stored procedure and code
generator that supports Microsoft SQL Server, Oracle, IBM DB2 UDB, PostgreSQL
and MySQL. It processes any tables and views in the Banque de données that you select
and generate stored procedures scripts of insert, update, delete, select (single
or multiple records) as well as Affaires entities for C# and VB.NET. The output
scripts file can be chosen as one file for all tables / views or one per table /
view based on your preference.  Below is how it works:

1. Collect metadata from different datasource(Oracle, DB2, SQL Server, MySQL, PostgreSQL)
2. Build xml metadata input definition file
3. Generate stored procedures and C# or VB.NET Affaires entity using xslt with different xsl stlysheets.

Lattice.SPGen supports the following RDBMS:
* MS SQL Server 2000 and 7, MSDE 2000.
* Oracle 8i and 9i.
* IBM DB2 UDB
* MySQL 5.0
* PostgreSQL

Below is the link to Télécharger the software:
http://www.latticesoft.com/downloads/LatticeSPGen.zip


Lattice Affaires Software
http://www.latticesoft.com