Show / Hide Table of Contents

    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.
    Back to top Generated by Appeon