Class NpgsqlSqlExpressionFactory
Inheritance
object
NpgsqlSqlExpressionFactory
Assembly: Npgsql.EntityFrameworkCore.PostgreSQL.dll
Syntax
public class NpgsqlSqlExpressionFactory : SqlExpressionFactory
Constructors
|
Improve this Doc
View Source
NpgsqlSqlExpressionFactory(SqlExpressionFactoryDependencies)
Declaration
public NpgsqlSqlExpressionFactory(SqlExpressionFactoryDependencies dependencies)
Parameters
Type |
Name |
Description |
SqlExpressionFactoryDependencies |
dependencies |
Parameter object containing dependencies for this class.
|
Methods
|
Improve this Doc
View Source
AggregateFunction(string, IEnumerable<SqlExpression>, EnumerableExpression, bool, IEnumerable<bool>, Type, RelationalTypeMapping?)
Declaration
public virtual PostgresFunctionExpression AggregateFunction(string name, IEnumerable<SqlExpression> arguments, EnumerableExpression aggregateEnumerableExpression, bool nullable, IEnumerable<bool> argumentsPropagateNullability, Type returnType, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
string |
name |
|
IEnumerable<><SqlExpression> |
arguments |
|
EnumerableExpression |
aggregateEnumerableExpression |
|
bool |
nullable |
|
IEnumerable<><bool> |
argumentsPropagateNullability |
|
Type |
returnType |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
|
Improve this Doc
View Source
All(SqlExpression, SqlExpression, PostgresAllOperatorType)
Declaration
public virtual PostgresAllExpression All(SqlExpression item, SqlExpression array, PostgresAllOperatorType operatorType)
Parameters
Returns
|
Improve this Doc
View Source
Any(SqlExpression, SqlExpression, PostgresAnyOperatorType)
Declaration
public virtual PostgresAnyExpression Any(SqlExpression item, SqlExpression array, PostgresAnyOperatorType operatorType)
Parameters
Returns
|
Improve this Doc
View Source
ApplyTypeMapping(SqlExpression?, RelationalTypeMapping?)
Declaration
public override SqlExpression? ApplyTypeMapping(SqlExpression? sqlExpression, RelationalTypeMapping? typeMapping)
Parameters
Type |
Name |
Description |
SqlExpression? |
sqlExpression |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
Type |
Description |
SqlExpression? |
|
|
Improve this Doc
View Source
ArrayIndex(SqlExpression, SqlExpression, RelationalTypeMapping?)
Declaration
public virtual PostgresArrayIndexExpression ArrayIndex(SqlExpression array, SqlExpression index, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
SqlExpression |
array |
|
SqlExpression |
index |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
|
Improve this Doc
View Source
AtTimeZone(SqlExpression, SqlExpression, Type, RelationalTypeMapping?)
Creates a new , for converting a timestamp to another time zone.
Declaration
public virtual AtTimeZoneExpression AtTimeZone(SqlExpression timestamp, SqlExpression timeZone, Type type, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
SqlExpression |
timestamp |
|
SqlExpression |
timeZone |
|
Type |
type |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
Type |
Description |
AtTimeZoneExpression |
|
|
Improve this Doc
View Source
AtUtc(SqlExpression, RelationalTypeMapping?)
Creates a new , for converting a timestamp to UTC.
Declaration
public virtual AtTimeZoneExpression AtUtc(SqlExpression timestamp, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
SqlExpression |
timestamp |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
Type |
Description |
AtTimeZoneExpression |
|
|
Improve this Doc
View Source
ContainedBy(SqlExpression, SqlExpression)
Declaration
public virtual PostgresBinaryExpression ContainedBy(SqlExpression left, SqlExpression right)
Parameters
Type |
Name |
Description |
SqlExpression |
left |
|
SqlExpression |
right |
|
Returns
|
Improve this Doc
View Source
Contains(SqlExpression, SqlExpression)
Declaration
public virtual PostgresBinaryExpression Contains(SqlExpression left, SqlExpression right)
Parameters
Type |
Name |
Description |
SqlExpression |
left |
|
SqlExpression |
right |
|
Returns
|
Improve this Doc
View Source
GenerateOneBasedIndexExpression(SqlExpression)
PostgreSQL array indexing is 1-based. If the index happens to be a constant,
just increment it. Otherwise, append a +1 in the SQL.
Declaration
public virtual SqlExpression GenerateOneBasedIndexExpression(SqlExpression expression)
Parameters
Type |
Name |
Description |
SqlExpression |
expression |
|
Returns
Type |
Description |
SqlExpression |
|
|
Improve this Doc
View Source
ILike(SqlExpression, SqlExpression, SqlExpression?)
Creates a new , for performing a PostgreSQL-specific case-insensitive string match
(ILIKE
).
Declaration
public virtual PostgresILikeExpression ILike(SqlExpression match, SqlExpression pattern, SqlExpression? escapeChar = null)
Parameters
Type |
Name |
Description |
SqlExpression |
match |
|
SqlExpression |
pattern |
|
SqlExpression? |
escapeChar |
|
Returns
|
Improve this Doc
View Source
JsonTraversal(SqlExpression, IEnumerable<SqlExpression>, bool, Type, RelationalTypeMapping?)
Declaration
public virtual PostgresJsonTraversalExpression JsonTraversal(SqlExpression expression, IEnumerable<SqlExpression> path, bool returnsText, Type type, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
SqlExpression |
expression |
|
IEnumerable<><SqlExpression> |
path |
|
bool |
returnsText |
|
Type |
type |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
|
Improve this Doc
View Source
JsonTraversal(SqlExpression, bool, Type, RelationalTypeMapping?)
Declaration
public virtual PostgresJsonTraversalExpression JsonTraversal(SqlExpression expression, bool returnsText, Type type, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
SqlExpression |
expression |
|
bool |
returnsText |
|
Type |
type |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
|
Improve this Doc
View Source
MakeBinary(ExpressionType, SqlExpression, SqlExpression, RelationalTypeMapping?)
Declaration
public override SqlBinaryExpression? MakeBinary(ExpressionType operatorType, SqlExpression left, SqlExpression right, RelationalTypeMapping? typeMapping)
Parameters
Type |
Name |
Description |
ExpressionType |
operatorType |
|
SqlExpression |
left |
|
SqlExpression |
right |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
Type |
Description |
SqlBinaryExpression? |
|
|
Improve this Doc
View Source
MakePostgresBinary(PostgresExpressionType, SqlExpression, SqlExpression, RelationalTypeMapping?)
Declaration
public virtual PostgresBinaryExpression MakePostgresBinary(PostgresExpressionType operatorType, SqlExpression left, SqlExpression right, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
PostgresExpressionType |
operatorType |
An System.Linq.Expressions.ExpressionType representing SQL unary operator.
|
SqlExpression |
left |
The left operand of binary operation.
|
SqlExpression |
right |
The right operand of binary operation.
|
RelationalTypeMapping? |
typeMapping |
A type mapping to be assigned to the created expression.
|
Returns
|
Improve this Doc
View Source
NewArray(IReadOnlyList<SqlExpression>, Type, RelationalTypeMapping?)
Declaration
public virtual PostgresNewArrayExpression NewArray(IReadOnlyList<SqlExpression> expressions, Type type, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
IReadOnlyList<><SqlExpression> |
expressions |
|
Type |
type |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
|
Improve this Doc
View Source
NewArrayOrConstant(IReadOnlyList<SqlExpression>, Type, RelationalTypeMapping?)
Declaration
public virtual SqlExpression NewArrayOrConstant(IReadOnlyList<SqlExpression> expressions, Type type, RelationalTypeMapping? typeMapping = null)
Parameters
Type |
Name |
Description |
IReadOnlyList<><SqlExpression> |
expressions |
|
Type |
type |
|
RelationalTypeMapping? |
typeMapping |
|
Returns
Type |
Description |
SqlExpression |
|
|
Improve this Doc
View Source
Overlaps(SqlExpression, SqlExpression)
Declaration
public virtual PostgresBinaryExpression Overlaps(SqlExpression left, SqlExpression right)
Parameters
Type |
Name |
Description |
SqlExpression |
left |
|
SqlExpression |
right |
|
Returns
|
Improve this Doc
View Source
RegexMatch(SqlExpression, SqlExpression, RegexOptions)
Declaration
public virtual PostgresRegexMatchExpression RegexMatch(SqlExpression match, SqlExpression pattern, RegexOptions options)
Parameters
Type |
Name |
Description |
SqlExpression |
match |
|
SqlExpression |
pattern |
|
RegexOptions |
options |
|
Returns