|
|
DalAddin
Author: ARSoft
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.
 Download now
 Click to buy from RegNow
Other products from ARSoft :
- DalAddin (Software Development > IDEs & Coding Utilities)
- ExploRAS 8 Ports (Utilities > Network)
Click here to view all products list from ARSoft ...
|
| |
| Related Software |
ABCFind
Visual Basic has always lacked a powerful Search and Replace tool. Until now!ABCFind provides a host of powerful features that significantly increase the day-to-day productivity of a Visual Bas ...
Download free!
ADO Data Class Builder
The ADO Data Class Builder Component is a COM-based component that encapsulates database functionality in class modules. The ADO Data Class Builder can build an entire class module from virtually any ...
Download free!
AntiCutAndPaste 1.0
AntiCutAndPaste is designed to search for text fragments that have been copied and pasted in programming language source code or plain text. It is tested on sources from large C++, Visual Basic, Delphi, Java, and C# projects. Algorithms used are very fast and can handle up to three million C++ code lines in one minute. Minor modifications of code are ignored during the search. GUI and command line versions are included.
Download free!
AppsChannel for MS Office
AppsChannels let you peek behind the scenes by creating automatic interfaces to referenced components, such as dynamic-link libraries (DLL's) and ActiveX controls -- any COM object that has a type lib ...
Download free!
c-frame 2.3
c-frame is for cross-platform 'system programming' (development on Windows/Linux/UNIX). You can convert an existing plain ASCII C source file to a CFR format (displayed in an editor as frames). It has compiler support for MSVC++, gcc, and gcc for Win32. It supports GTK+, GTK+ for Win32 with MinGW, and X11 software development. It can run as a graphical application or as a terminal application. Each free download contains two self running demos.
Download free!
CobolScript 3.0
A COBOL based scripting language
Download free!
CobolScript for Linux 3.0
A COBOL based scripting language
Download free!
|
|
|
|
|
