TiTaN Code Generator - CodeProject

Download TiTaN classes setup - 607.6 KB

Introduction

Are you tired from writing the same code again and again? If you are using data access layers techniques in your development so this article for you! The main purpose for the application is to generate the class will deal with the database and save your time to the hard work.

Screenshot - 1.jpg

Background

The data access layers techniques that i am going to talk about it is 3 tiers:

The database (stored procedures)
The class (our subject)
The forms or the calling procedure

I knew that there are a lot of data access layers techniques but this is one of them and i think it's ok

Requirements

.NET Framework 1.1 Download
WinRAR

Using the Code

If you are using sql server database this will be perfect for you especially in next versions but if you are using other database it's ok but you will not have the facilities the application provide to the users

all you have to do setup the application , you will find a sample folder on your desktop this will help you to understand how the process is going in the application (attach database and then read the code read especially comments, and there is a help file but i am sorry it's now in Arabic but soon it will be in English

Screenshot - 2.jpg

Steps :

Choose database from the list if it's working or add it by your self if it's not
Choose columns and data types for it
Be careful if you have a primary key in the table you are creating a class for it you have to say this column is a primary key when you adding it to the list because this will affect the process of creating stored procedure and classes
After finishing the last step just say the kin of stored procedure if you want it (recommended) and then add them to your database stored procedures
Finally choose the output file if it's vb or c# or txt or dll but the only things are working now is txt and vb files but in next version it will work perfectly

Thats all