Database Components Hxj.data (ix) (Other dbsession introduction)

This section describes other simple helper methods for dbsession.

Sum method

Dbsession.default.sum<products> (products._. UnitPrice, Products._. CategoryID = = 2);

Returns the UnitPrice total for categroyid=2.

Avg Method

Dbsession.default.avg<products> (products._. UnitPrice, Products._. CategoryID = = 2);

Returns the average of the UnitPrice of the categroyid=2.

Count method

Dbsession.default.count<products> (products._. All, products._. CategoryID = = 2);

Returns the number of record bars for the categroyid=2.

Max method

Dbsession.default.max<products> (products._. UnitPrice, Products._. CategoryID = = 2);

Returns the largest unitprice in a categroyid=2 record.

Min method

Dbsession.default.min<products> (products._. UnitPrice, Products._. CategoryID = = 2);

Returns the smallest UnitPrice in a categroyid=2 record.

There are few ways to assist, just a few.

The next section describes how to output the SQL that the component executes.