The SelectCommand type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | Aggregates | The columns composed of aggregate functions to return data for. Optional. |
| Columns | The columns to return data for. Optional. |
| ContactList |
The contact list to run this command against.
(Inherited from ContactListCommand.) |
| Distinct | Specifies whether to return only records which are distinct. |
| Filters | The filter to use in the where predicate. (Inherited from ContactListCommand.) |
| FirstRecord |
The number of the first record to retrieve as part of a paged result.
|
| GroupBy | The columns to group records by, in order. |
| Having | An expression representing a logical predicate with which to filter records. |
| LastRecord |
The number of the last record to retrieve as part of a paged result.
|
| OrderBy | A list of key/value pairs representing the sorting order of the results. The key is the column name, and the value is true for ascending and false for descending. |
| RecordsAffected |
The number of records affected by this command. If this is a paged SelectCommand, the value reflects the total number of records in the unpaged version.
(Inherited from ContactListCommand.) |
| TableType |
Specifies which associated database table to run the command on. Defaults to the contact list table.
(Overrides ContactListCommand..::..TableType.) |
| Where | An expression representing a logical predicate with which to filter records. (Inherited from ContactListCommand.) |
