This folder also contains the Table Binding Files (TBF) that contains information about the database schema and other information used by Iron Speed Designer. There is one file for every table used by the application.
Each Record and Table has a corresponding pair of classes: a “base” class and a “customizable” class. The customizable classes are created only once and it is safe to include custom application logic within them without fear of them being overwritten.
File
|
Function
|
Database schema files
<TABLE>Table.xml
<VIEW>View.xml
<QUERY>Query.xml
|
Database schema files are used by Iron Speed Designer to specify the database schema for the designated table, view or query.
<TABLE> is the name of the database table.
Example: OrdersTable.xml
|
Record class files
<TABLE>Record.vb
<VIEW>Record.vb
<QUERY>Record.vb
Base<TABLE>Record.vb
Base<VIEW>Record.vb
Base<QUERY>Record.vb
|
The Record family of classes corresponds to a record in the database and implements logic to get data from the object and set data into the object.
A customizable class is created for the Record class. Since this class is created only once, it is safe to include custom application logic within the class without fear of it being overwritten.
|
Table class files
<TABLE>Table.vb
<VIEW>View.vb
<QUERY>Query.vb
Base<TABLE>Table.vb
Base<VIEW>View.vb
Base<QUERY>Query.vb
|
The Table family of classes implement logic to retrieve a set of records based on a filter. The developer can specify the filtering criteria or the application user can specify the criteria through user selectable controls.
A customizable class is created for the table, database view, or query. Since this class is created only once, it is safe to include custom application logic within the class without fear of it being overwritten.
|
Table Definition class files
|
The application uses the table schema information of a database table to access, update and delete data from the application’s database tables. The schema information is stored in a class created by Iron Speed Designer.
The class is called <Table>Definition and is created in a file called <Table>Definition.vb.
This class is overwritten whenever the table schema information changes as a result of refreshing a database table schema. There is no customizable class created for this class as it does not typically need to be modified by you.
|
SQL Interface class files
|
The SQL interface class contains the access code to retrieve data from and save data to the database through the application’s stored procedures.
The class is called <Table>SqlAccessGen and is created in a file called <Table>SqlAccess.gen.vb.
This class is only created for tables and views, but not for table joins.
|
File Name
|
Description
|
Base<TABLE>Record.vb
|
The record class named Base<TABLE>Record.
|
<TABLE>Record.vb
|
The customizable record class named <TABLE>Record.
|
Base<TABLE>Table.vb
Base<TABLE>View.vb
Base<TABLE>Query.vb
|
Table, view or query class named Base<TABLE>Table.
|
<TABLE>Table.vb
<TABLE>View.vb
<TABLE>Query.vb
|
Table, view or query customizable class named <TABLE>Table.
|
<TABLE>Definition.vb
|
The table schema information class named <TABLE>Definition.
|
<TABLE>SqlAccess.gen.vb
|
The SQL interface class named <TABLE>SqlAccessGen used to call the application’s stored procedures.
|
For example, a table called "Orders" will have these Data Access Layer files.