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.
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
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
Points of Interest
How to make users happy
History
*********************
