There are
many code segments in this manual. Please read following notes in order to
understand those examples better.
1. All the examples use the Northwind database with Microsoft SQL
Server.
2. The plural 's' is removed from the alias of all the table names.
3. "NW" is the name of the query framework, it is the abbreviation
of the data schema "Northwind". You may set the abbreviation of the
schema in CodeAuto, please refer to "3.1.2
Code Generation". Divide a big data schema into several sub-schemas
is a good habit. Give sub-schema a short name will make it more conveniently
while coding.
|
SelectQuery qryProduct
= OQL .SelectFrom(NW.Product) .Where(NW.Product.UnitPrice * NW.Product.UnitsInStock >= 1000); |