RAD Studio Code Generation Toolkit

RAD Studio Code Generation Toolkit
RAD Studio is the ultimate class object creator / stored procedure generator and data tier creator for C# and other Visual Studio developers.

RAD Studio is written in C# and creates a 100% stored procedure driven data tier based on any SQL Server database.

RAD Studio reads the database schema for any SQL Server database and creates a class object for all tables in the database.

The class objects created use partial classes so for each table in your databae you will have the following files created:

<Table Name>.data.cs
<Table Name>.business.cs

The business class also includes a collection class for each table so you can handle multiple instance of each type of data object.

The advantage to using partial classes is that the data class can be updated if the database model changes and the business class will not be overwritten so you can add custom properies and methods to the business class.

RAD Studio creates a 100% stored procedure driven data tier that handles the full CRUD methods so you can focus on the business rules and functionality of your application or web project.

Data Readers are code generated that load the class objects from the DataSet returned from the stored procedure.

Data Writers are created to add the parameters for any stored procedures used in your database(s).
A base class is created for each Data Writer and a derived class is used so that you may override any methods in the base class to call an alternate stored procedure if you need functionality that is not created by RAD Studio.

A stored procedure generator creates the following stored procedures for each table:
Insert
Update
Delete
Find *
FetchAll *

• Find returns a single instance of an object where FetchAll returns a collection of data objects.

RAD Studio uses the Microsoft Application Block for Data.

RAD Studio versus LINQ

Advantages of LINQ:

• LINQ is integrated with Visual Studio where RAD Studio is executed as a stand alone application at this time.
• LINQ has other uses in addition to SQL Server such as LINQ to XML and querying arrays and lists.

Advantages of RAD Studio:

• RAD Studio uses stored procedures where LINQ uses dynamic SQL unless you specifically call a stored procedure.
• RAD Studio creates code that is much easier to read and perfectly formatted where LINQ is very sloppy to read the code with all of the changes sets that LINQ uses to keeps track of changes in your objects.
• RAD Studio comes with Project Templates to allow you create database projects quickly.
• Since you are using code you can customize how the data is manipulated where with LINQ you do not have that ability.
• RAD Studio supports enumerations