Search Results for

    Show / Hide Table of Contents

    Class NpgsqlQuerySqlGenerator

    The default query SQL generator for Npgsql.

    Inheritance
    object
    NpgsqlQuerySqlGenerator
    Namespace: Npgsql.EntityFrameworkCore.PostgreSQL.Query.Internal
    Assembly: Npgsql.EntityFrameworkCore.PostgreSQL.dll
    Syntax
    public class NpgsqlQuerySqlGenerator : QuerySqlGenerator

    Constructors

    | Improve this Doc View Source

    NpgsqlQuerySqlGenerator(QuerySqlGeneratorDependencies, bool, Version)

    Declaration
    public NpgsqlQuerySqlGenerator(QuerySqlGeneratorDependencies dependencies, bool reverseNullOrderingEnabled, Version postgresVersion)
    Parameters
    Type Name Description
    QuerySqlGeneratorDependencies dependencies
    bool reverseNullOrderingEnabled
    Version postgresVersion

    Methods

    | Improve this Doc View Source

    GenerateLimitOffset(SelectExpression)

    Declaration
    protected override void GenerateLimitOffset(SelectExpression selectExpression)
    Parameters
    Type Name Description
    SelectExpression selectExpression
    | Improve this Doc View Source

    GenerateRootCommand(Expression)

    Declaration
    protected override void GenerateRootCommand(Expression queryExpression)
    Parameters
    Type Name Description
    Expression queryExpression
    | Improve this Doc View Source

    GenerateSetOperationOperand(SetOperationBase, SelectExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected override void GenerateSetOperationOperand(SetOperationBase setOperation, SelectExpression operand)
    Parameters
    Type Name Description
    SetOperationBase setOperation
    SelectExpression operand
    | Improve this Doc View Source

    GenerateTop(SelectExpression)

    Declaration
    protected override void GenerateTop(SelectExpression selectExpression)
    Parameters
    Type Name Description
    SelectExpression selectExpression
    | Improve this Doc View Source

    GetOperator(SqlBinaryExpression)

    Declaration
    protected override string GetOperator(SqlBinaryExpression e)
    Parameters
    Type Name Description
    SqlBinaryExpression e
    Returns
    Type Description
    string
    | Improve this Doc View Source

    VisitArrayAll(PostgresAllExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    public virtual Expression VisitArrayAll(PostgresAllExpression expression)
    Parameters
    Type Name Description
    PostgresAllExpression expression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitArrayAny(PostgresAnyExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    public virtual Expression VisitArrayAny(PostgresAnyExpression expression)
    Parameters
    Type Name Description
    PostgresAnyExpression expression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitArrayIndex(PostgresArrayIndexExpression)

    Produces SQL array index expression (e.g. arr[1]).

    Declaration
    public virtual Expression VisitArrayIndex(PostgresArrayIndexExpression expression)
    Parameters
    Type Name Description
    PostgresArrayIndexExpression expression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitArrayIndex(SqlBinaryExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected virtual Expression VisitArrayIndex(SqlBinaryExpression expression)
    Parameters
    Type Name Description
    SqlBinaryExpression expression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitCollate(CollateExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected override Expression VisitCollate(CollateExpression collateExpresion)
    Parameters
    Type Name Description
    CollateExpression collateExpresion
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitCrossApply(CrossApplyExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected override Expression VisitCrossApply(CrossApplyExpression crossApplyExpression)
    Parameters
    Type Name Description
    CrossApplyExpression crossApplyExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitDelete(DeleteExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected override Expression VisitDelete(DeleteExpression deleteExpression)
    Parameters
    Type Name Description
    DeleteExpression deleteExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitExtension(Expression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected override Expression VisitExtension(Expression extensionExpression)
    Parameters
    Type Name Description
    Expression extensionExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitILike(PostgresILikeExpression)

    Visits the children of an PostgresILikeExpression.

    Declaration
    public virtual Expression VisitILike(PostgresILikeExpression likeExpression)
    Parameters
    Type Name Description
    PostgresILikeExpression likeExpression

    The expression.

    Returns
    Type Description
    Expression

    An .

    | Improve this Doc View Source

    VisitJsonPathTraversal(PostgresJsonTraversalExpression)

    Visits the children of an PostgresJsonTraversalExpression.

    Declaration
    public virtual Expression VisitJsonPathTraversal(PostgresJsonTraversalExpression expression)
    Parameters
    Type Name Description
    PostgresJsonTraversalExpression expression

    The expression.

    Returns
    Type Description
    Expression

    An .

    | Improve this Doc View Source

    VisitOrdering(OrderingExpression)

    Declaration
    protected override Expression VisitOrdering(OrderingExpression ordering)
    Parameters
    Type Name Description
    OrderingExpression ordering
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitOuterApply(OuterApplyExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected override Expression VisitOuterApply(OuterApplyExpression outerApplyExpression)
    Parameters
    Type Name Description
    OuterApplyExpression outerApplyExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitPostgresBinary(PostgresBinaryExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected virtual Expression VisitPostgresBinary(PostgresBinaryExpression binaryExpression)
    Parameters
    Type Name Description
    PostgresBinaryExpression binaryExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitPostgresDelete(PostgresDeleteExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected virtual Expression VisitPostgresDelete(PostgresDeleteExpression pgDeleteExpression)
    Parameters
    Type Name Description
    PostgresDeleteExpression pgDeleteExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitPostgresFunction(PostgresFunctionExpression)

    Visits the children of a PostgresFunctionExpression.

    Declaration
    public virtual Expression VisitPostgresFunction(PostgresFunctionExpression e)
    Parameters
    Type Name Description
    PostgresFunctionExpression e

    The expression.

    Returns
    Type Description
    Expression

    An .

    | Improve this Doc View Source

    VisitPostgresNewArray(PostgresNewArrayExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected virtual Expression VisitPostgresNewArray(PostgresNewArrayExpression postgresNewArrayExpression)
    Parameters
    Type Name Description
    PostgresNewArrayExpression postgresNewArrayExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitRegexMatch(PostgresRegexMatchExpression)

    Visits the children of a PostgresRegexMatchExpression.

    Declaration
    public virtual Expression VisitRegexMatch(PostgresRegexMatchExpression expression)
    Parameters
    Type Name Description
    PostgresRegexMatchExpression expression

    The expression.

    Returns
    Type Description
    Expression

    An .

    Remarks

    See: http://www.postgresql.org/docs/current/static/functions-matching.html

    | Improve this Doc View Source

    VisitRowValue(PostgresRowValueExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    public virtual Expression VisitRowValue(PostgresRowValueExpression rowValueExpression)
    Parameters
    Type Name Description
    PostgresRowValueExpression rowValueExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitSqlBinary(SqlBinaryExpression)

    Declaration
    protected override Expression VisitSqlBinary(SqlBinaryExpression binary)
    Parameters
    Type Name Description
    SqlBinaryExpression binary
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitSqlUnary(SqlUnaryExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected override Expression VisitSqlUnary(SqlUnaryExpression sqlUnaryExpression)
    Parameters
    Type Name Description
    SqlUnaryExpression sqlUnaryExpression
    Returns
    Type Description
    Expression
    | Improve this Doc View Source

    VisitUnknownBinary(PostgresUnknownBinaryExpression)

    Visits the children of a PostgresUnknownBinaryExpression.

    Declaration
    public virtual Expression VisitUnknownBinary(PostgresUnknownBinaryExpression unknownBinaryExpression)
    Parameters
    Type Name Description
    PostgresUnknownBinaryExpression unknownBinaryExpression

    The expression.

    Returns
    Type Description
    Expression

    An .

    | Improve this Doc View Source

    VisitUpdate(UpdateExpression)

    This is an internal API that supports the Entity Framework Core infrastructure and not subject to the same compatibility standards as public APIs. It may be changed or removed without notice in any release. You should only use it directly in your code with extreme caution and knowing that doing so can result in application failures when updating to a new Entity Framework Core release.

    Declaration
    protected override Expression VisitUpdate(UpdateExpression updateExpression)
    Parameters
    Type Name Description
    UpdateExpression updateExpression
    Returns
    Type Description
    Expression
    • Improve this Doc
    • View Source
    In This Article
    Back to top © Copyright 2023 The Npgsql Development Team