| DalAddin |
Homepage
DalAddinDalAddin is an Addin for Visual Basic 6.0 wich facilitates enormously the development of applications in N-tiers with SQL Server, smartly generating a great part of the data layer including store procedures for insert, delete, update, select by the primar
Description of 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 Retu50.00 See Also: All products from ARSoft |
Related Software Download:
| New Released Software: more »
| |
| ||
| Copyright © 2000 - 2007 - Shareup Downloads - A Free Service of Shareup LLC. All Rights Reserved. |
| Home | Most Recent 100 Software | Privacy Policy | Directory | Contact Shareup |