SUMMARY OF DATALG GENERATED ASSEMBLIES FUNCTIONALITIES
The generated assemblies are comprised of two main parts. One is the database connection object,
the other is the group of namespace use to relate to each item included from the database, such
as tables, views and stored procedures.
|
The connection object is adapted to the database system that it will interact with. There
is no need for a connection string, you can open the connection by specifying the necessary
parameters in it's constructor, or by defining it's properties. The connection object operates
by default in auto-connect mode, which takes care of opening the connection and closing it
after. It allows to do simple data transactions without writing the code to open and close
the connection.
The connection object allows transactions for both Ms Access 2000 and Ms Sql Server 2000 module.
LIST OF FUNCTIONALITES
Each item of the database represented in a namespace ususally has 5 different classes :
|
- Class Operation
This class holds all the methods to interact between the database server and the the 4 other
classes. These are some of the methods that are present depending on the type of object
(table, view or stored procedure) :
- Select : to select rows
- Update : to update rows
- Insert : to insert rows
- Delete : to delete rows
- Count : to count rows
- Min, Max : to find the maximum and minimum value for a column
- Call : to execute a stored procedure
- Class Row
This class holds the representation of a row in the database item. The different members
of this class are the fields present of the database item, with their types mapped accordingly.
This class holds a method to clone itself. It can be use to retrieve, create and modify
rows.
- Class Rows
This class inherits the System.Collections.CollectionBase class of the .Net Framework.
It is a collection of Row objects, and it holds some useful methods and properties,
such as :
- Add : to add a new Row class object
- Contains : to check if a Row object in the collection has a field with a specific value.
- Find : to retrieve another Rows object that contains Row objects with a specific value for a field.
- Count : to count the Row objects
- Min, Max : to find the maximum and minimum value for a column
- Class Param
This class is used to perform the different methods in the Operation class.
- Class Params
This class inherits the System.Collections.CollectionBase class of the .Net Framework.
It is a collection of Param objects.
|