OQL.NET Introduction
OQL.NET Introduction
OQL.NET's Advantages
Important Notes
Using OQL.NET
Generating Query Schema
CodeAuto Code Generator
Code Generation
Reference to OQL.NET
Single Database Environment
Multi-database Environment
Using OQL.NET in ADO.NET
Using DataReader
Using DataSet
Using OQL.NET in O/R Mapping
OQL Expressions
Compute Expression
Boolean Expression
Comparison Expression
In Expression
Like Expression
Object Expression
OQL Statement
Select Statement
Single Table Select
Select All the Fields
Select Some Fields
Multi-table Select
Using Where
Using Join
Using Sub-query
Using Object Expression
Update Statement
Using Constant
Using Expression
Insert Statement
Using Constant
Using Select Clause
Delete Statement
OQL Clauses
Select Clause
SelectFrom
SelectWhere
From Clause
Join Clause
On Clause
Where Clause
GroupBy Clause
Having Clause
OrderBy Clause
Case Clause
Simple Case
Complicated Case
OQL Functions
Aggregate Function
Count Function
Sum and Avg Function
Max and Min Function
Dynamic Construction of OQL
Constructing a Select Clause
Constructing a From Clause
Constructing Query Conditions
Constructing GroupBy Clause
Constructing OrderBy Clause
Advanced Usage
Code Refactoring
Object Expression