Lattice.SPGen Stored Procedure and Code Generator Publisher's description
Lattice.SPGen is a stored procedure and code (C# and VB.NET) generator wizard that supports Microsoft SQL Server, Oracle, IBM DB2 UDB, MySQL and PostgreSQL.
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 database that you select and generate stored procedures scripts of insert, update, delete, select (single or multiple records) as well as business 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 business 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
System Requirements:Microsoft .NET Framework 2.0 or newer
Microsoft Windows Installer 3.0
Program Release Status: New Release
Program Install Support: Install and Uninstall