DalAddin

In only three steps save hours:

1. Connect to a SQL Server.

2. Select tha database.

3. If you are starting a proyect or if you have added tables to the database:


Click the 'Generate From Tables' TAB


Select the tables and press the generate button. DalAddin will include in your active proyect:


· A module with data access routines.


· A module with COM+ and error handling routines.


· References to COM+, Microsoft XML and ADO.


· For each table selected it will include a class with the following methods:


o ins[TableName](updatable fields). This method executes a store procedure generated by DalAddin wich inserts a record in the table and if the table has an identity column, it returns it as a result.


o del[TableName](PrimaryKey or IdentityColumn). This method executes a store procedure generated by DalAddin wich delete a record from the table.


o upd[TableName](TableFields). This method executes a store procedure generated by DalAddin wich updates a record searching for it through the PrimaryKey or IdentityColumn and returns the amount of updated records (1 if it was found or 0 if it was not found).


o GetAll(). This method executes a store procedure generated by DalAddin wich returns all the records.


o Get[TableName]( PrimaryKey or IdentityColumn). This method executes a store procedure generated by DalAddin wich returns a record looking for it thruogh the primary key or identity column.


o Get[TableName]By[KeyColumns]( KeyColumns). It generates a method for each foreign key and another one for each field of the key.


o Get[TableName]By[IndexColumns]( KeyColumns). It generates a method for each index.


If it is an already started project and you need to add a data method.


Click the 'Generate From Tables' TAB


Select a Store Procedure and press:


· Generate DAL Method Return RS if the store procedure is a select. You will obtain the code of the method to call that Store Procedure.


· Generate DAL Method Return Int you will obtain the code of the method to call that Store Procedure. If the Store Procedure has an output parameter it returs it, if not it returns the amount of records affected by the Store Procedure.


· Generate BUS Method Return RS. You will obtain the code of the method to call to the routine of the data layer wich executes the Store Procedure.


· Generate BUS Method Return Int. You will obtain the code of the method to call to the routine of the data layer wich executes the Store Procedure.