CodeGenerator

Description:

Generates Stored Procedure for Oracle and Sql Server database, Data Access Layer Code and Entity classes for C#

Requirements:

.Net Framework (WPF), Oracle Client if you want to generate code from Oracle Database

Configuration:

Open the app.config file, update the following information:

1. value="SqlServer" if sql server database or value="Oracle" if oracle database
2. Put the name/code of your project in place of STS
3. If SqlServer then following config block will be application

Else if Oracle the following config block will be application

update the ConString with your projects Connection String Property

the value of "PkColName" key will be the primary key column name of your table
the value of "RecordCreatorColName" key will be the Record Creator's column name of your table
the value of "RecordModifierColName" key will be the Record Modifier's column name of your table
the value of "RecordCreateDateColName" key will be the Record Creation timestamp column name of your table
the value of "RecordCreateDateColName" key will be the Record Modification timestamp column name of your table

usually all the above 5 columns name should be unique in all tables of your database

Run:

Then run the Project/EXE all tables of your connected database will available in the Drop down list Select 1 table and click on the buttons to generate the Code for you. The generated files will available at the path defided in