QuerySelector Enum
.NET Standard 2.x
Specifies the query method to be used when loading the data for a property where the EmbeddedModel attribute is applied in a model class.
Namespace: SnapObjects.Data
Assembly: SnapObjects.Data.dll
Syntax
public enum QuerySelector
Members
| Member Name | Description |
|---|---|
| Scalar | Retrieves the first column in the first row for the specified SQL expression. |
| ScalarByKey | Retrieves the first column in the first row for the specified SQL expression. |
| Select | Retrieves records according to the SQL query predefined. |
| SelectByKey | Retrieves records according to the primary key. |
| SelectCount | Returns the number of rows in the result set. |
| SelectDistinctCount | Returns the number all distinct values specified by the SQL expression. |
| SelectMax | Retrieves the maximum value for the specified SQL expression. |
| SelectMin | Retrieves the minimum value for the specified SQL expression. |
| SelectAvg | Retrieves the average value using the specified SQL expression. |
| SelectSum | Retrieves the sum value using the specified SQL expression. |