buy DalAddin software

» Home » Software Development » IDEs & Coding Utilities » DalAddin

Title:	DalAddin
Price:	42.72 EUR
Screenshot:	No Screenshot
Downloads:	0

Date added:	Apr 19, 2006
Click here to buy

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.

NEWS

So far, nothing for that!

RECOMMENDED DOWNLOADS IN THIS CATEGORY

» Home » Software Development » IDEs & Coding Utilities (10)

Select page: [1]

» VS.Php 2.0 for Visual Studio 2005

Develop php applications from within Visual Studio 2005. This product lets you build, edit and deploy php applications using the familiar interface of the most popular IDE in the market. Contrary to other PHP IDE products, VS.Php leverages the familiar in ...