The manual includes many code segments, please read the following illustration to comprehend these codes better.
1. All the samples in the manual use Northwind database of Microsoft SQL Server.
2. The aliases of All databases with plural name will be changed to singular form in CodeAuto, for example, "Orders" is changed to "Order".
3. For the ObjectManager object appears in the codes, please refer to "4 Using DObject's Persistence Layer".
|
order :=
TOrder.GetByOrderID(ObjectManager, _orderId); |
4. The "NW" appears in the codes is the abbreviation of "Northwind", denoting the name of a query schema. The abbreviation "NW" is the "SchemaName" value being configured while CodeAuto generating codes (refer to "3.2 Generating Codes"). Dividing a big database into several sub-schemas is a good design habit. It will be more convenient to use them while writing codes by giving each of these sub-schemas an abbreviation name.
|
qryOrder .Select(NW.Order) .From(NW.Order) .Where(OQL .Criteria(NW.Order.EmployeeID).EQ(5) .And_(NW.Order.ShipVia).EQ(1) ); |