.NET tools, components, libraries and add-ins [NEW] My favorites| sign in | create your account  
ASP.NET hosting
Advertise here! Contact us to know the options


Categories: Persistence - Data-tier

Author: Lattice Business Software International

Latest version: 2.0
Added 2005-04-09

Stored procedure generator that supports Oracle, SQL Server and DB2 UDB.

Lattice.SPGen is a template-based code generator using XSLT with different XSL style sheets to generate stored procedures and Data Transfer Objects in both C# and VB.NET. Lattice.SPGen will process each table and view in the database that you selected and create stored procedures to insert, update, delete, select (single or multiple records) using the fields you choose as well as using stored procedure name you desire.

Features include:
- Generate Insert, Select, Update, and Delete stored procedures.
- Generate stored procedures to select all rows based on foreign key definitions.
- Support Oracle package and sequence number.
- Return identity id for SQL server and sequence number for Oracle.
- Support composite primary key
- Support either Windows Login or SQL Server Login (SQL Server).
- Option to generate one big SQL script file or generate each file per table
- Option to generate XML metadata definition file
- Option to generate mapping files for Lattice.DataMapper
- Support Oracle 8i, 9i and 10g, SQL Server 2000 and 7, MSDE 2000, IBM DB2 UDB.

Built for .NET
Built for .NET
Advertise here! Contact us to know the options
Help the .NET community get a consensus on great tools. Display your favorite tools on your own website or on your blog.
Keep track of your favorite tools. Build your personal watch list.
Advertise here! Contact us to know the options
Hosted by Arvixe
part of the metaSapiens network: metaSapiens | .NET Jobs | Fabrice's weblog | .NET tools | Java tools | Dynamics AX tools | Tuneo | LINQ book | MapShares | BD indépendante | Parking partagé