Class NpgsqlQuerySqlGenerator
The default query SQL generator for Npgsql.
Inheritance
object
NpgsqlQuerySqlGenerator
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
|
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
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
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
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)
Declaration
public virtual Expression VisitILike(PostgresILikeExpression likeExpression)
Parameters
Returns
Type |
Description |
Expression |
An .
|
|
Improve this Doc
View Source
VisitJsonPathTraversal(PostgresJsonTraversalExpression)
Declaration
public virtual Expression VisitJsonPathTraversal(PostgresJsonTraversalExpression expression)
Parameters
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
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
Returns
Type |
Description |
Expression |
|
|
Improve this Doc
View Source
VisitPostgresFunction(PostgresFunctionExpression)
Declaration
public virtual Expression VisitPostgresFunction(PostgresFunctionExpression e)
Parameters
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
Returns
Type |
Description |
Expression |
|
|
Improve this Doc
View Source
VisitRegexMatch(PostgresRegexMatchExpression)
Declaration
public virtual Expression VisitRegexMatch(PostgresRegexMatchExpression expression)
Parameters
Returns
Type |
Description |
Expression |
An .
|
|
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
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)
Declaration
public virtual Expression VisitUnknownBinary(PostgresUnknownBinaryExpression unknownBinaryExpression)
Parameters
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 |
|