Partilhar via

SqlExpressionFactory Class

  • Reference

Definition

Namespace:
Microsoft.EntityFrameworkCore.Query
Assembly:
Microsoft.EntityFrameworkCore.Relational.dll
Package:
Microsoft.EntityFrameworkCore.Relational v3.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v3.1.0
Package:
Microsoft.EntityFrameworkCore.Relational v5.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v6.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v7.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v8.0.0
Package:
Microsoft.EntityFrameworkCore.Relational v9.0.0
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

A factory for creating SqlExpression instances.

public class SqlExpressionFactory : Microsoft.EntityFrameworkCore.Query.ISqlExpressionFactory
type SqlExpressionFactory = class
    interface ISqlExpressionFactory
Public Class SqlExpressionFactory
Implements ISqlExpressionFactory
Inheritance
Object
SqlExpressionFactory
Implements
ISqlExpressionFactory

Constructors

SqlExpressionFactory(SqlExpressionFactoryDependencies)

Creates a new instance of the SqlExpressionFactory class.

Properties

Dependencies

Dependencies for this service.

Methods

Add(SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a SqlExpression which represents an addition.
And(SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a SqlExpression which represents a bitwise AND operation.
AndAlso(SqlExpression, SqlExpression)

Creates a SqlExpression which represents a logical AND operation.
ApplyDefaultTypeMapping(SqlExpression)

Applies default type mapping to given SqlExpression.
ApplyTypeMapping(SqlExpression, RelationalTypeMapping)

Applies type mapping to the given SqlExpression.
Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Creates a new CaseExpression which represent a CASE statement in a SQL tree.
Case(SqlExpression, CaseWhenClause[])
Obsolete.

Creates a new CaseExpression which represent a CASE statement in a SQL tree.
Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression, SqlExpression)

Creates a new CaseExpression which represent a CASE statement in a SQL tree.
Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Creates a new CaseExpression which represent a CASE statement in a SQL tree.
Case(SqlExpression, SqlExpression, CaseWhenClause[])
Coalesce(SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a SqlExpression which represents a COALESCE operation.
Constant(Object, RelationalTypeMapping)

Creates a new SqlExpression which represents a constant in a SQL tree.
Constant(Object, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a constant in a SQL tree.
Convert(SqlExpression, Type, RelationalTypeMapping)

Creates a new SqlExpression which represent casting a SQL expression to different type.
Divide(SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a SqlExpression which represents a division.
Equal(SqlExpression, SqlExpression)

Creates a SqlExpression which represents an equality comparison.
Exists(SelectExpression, Boolean)

Creates a new ExistsExpression which represents an EXISTS operation in a SQL tree.
Exists(SelectExpression)

Creates a new ExistsExpression which represents an EXISTS operation in a SQL tree.
FindMapping(Type)
Obsolete.

Finds the type mapping for a given Type.
Fragment(String)

Creates a new SqlExpression which represents a SQL token.
Function(SqlExpression, String, IEnumerable<SqlExpression>, Boolean, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a function call in a SQL tree.
Function(SqlExpression, String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.
Function(SqlExpression, String, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.
Function(String, IEnumerable<SqlExpression>, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a function call in a SQL tree.
Function(String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.
Function(String, String, IEnumerable<SqlExpression>, Boolean, IEnumerable<Boolean>, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a function call in a SQL tree.
Function(String, String, IEnumerable<SqlExpression>, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.
Function(String, String, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.
Function(String, Type, RelationalTypeMapping)
Obsolete.

Creates a new SqlFunctionExpression which represents a function call in a SQL tree.
GetTypeMappingForValue(Object)
Obsolete.

Gets the relational database type for a given object, throwing if no mapping is found.
GreaterThan(SqlExpression, SqlExpression)

Creates a SqlExpression which represents a greater than comparison.
GreaterThanOrEqual(SqlExpression, SqlExpression)

Creates a SqlExpression which represents a greater than or equal comparison.
In(SqlExpression, IReadOnlyList<SqlExpression>)

Creates a new InExpression which represents an IN operation in a SQL tree.
In(SqlExpression, SelectExpression, Boolean)

Creates a new InExpression which represents an IN operation in a SQL tree.
In(SqlExpression, SelectExpression)

Creates a new InExpression which represents an IN operation in a SQL tree.
In(SqlExpression, SqlExpression, Boolean)

Creates a new InExpression which represents an IN operation in a SQL tree.
In(SqlExpression, SqlParameterExpression)

Creates a new InExpression which represents an IN operation in a SQL tree.
IsNotNull(SqlExpression)

Creates a new SqlExpression which represent inequality to null.
IsNull(SqlExpression)

Creates a new SqlExpression which represent equality to null.
LessThan(SqlExpression, SqlExpression)

Creates a SqlExpression which represents a less than comparison.
LessThanOrEqual(SqlExpression, SqlExpression)

Creates a SqlExpression which represents a less than or equal comparison.
Like(SqlExpression, SqlExpression, SqlExpression)

Creates a new InExpression which represents a LIKE in a SQL tree.
MakeBinary(ExpressionType, SqlExpression, SqlExpression, RelationalTypeMapping, SqlExpression)

Creates a new SqlExpression with the given arguments.
MakeBinary(ExpressionType, SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a new SqlBinaryExpression with the given arguments.
MakeUnary(ExpressionType, SqlExpression, Type, RelationalTypeMapping, SqlExpression)

Creates a new SqlExpression with the given arguments.
MakeUnary(ExpressionType, SqlExpression, Type, RelationalTypeMapping)

Creates a new SqlUnaryExpression with the given arguments.
Modulo(SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a SqlExpression which represents a modulo operation.
Multiply(SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a SqlExpression which represents a multiplication.
Negate(SqlExpression)

Creates a new SqlExpression which represent a negation operation in a SQL tree.
NiladicFunction(SqlExpression, String, Boolean, Boolean, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a niladic function call in a SQL tree.
NiladicFunction(String, Boolean, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a niladic function call in a SQL tree.
NiladicFunction(String, String, Boolean, Type, RelationalTypeMapping)

Creates a new SqlExpression which represents a niladic function call in a SQL tree.
Not(SqlExpression)

Creates a new SqlExpression which represent a NOT operation in a SQL tree.
NotEqual(SqlExpression, SqlExpression)

Creates a SqlExpression which represents an inequality comparison.
Or(SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a SqlExpression which represents a bitwise OR operation.
OrElse(SqlExpression, SqlExpression)

Creates a SqlExpression which represents a logical OR operation.
Select(IEntityType, String, Expression)
Obsolete.

Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source created using a custom SQL.
Select(IEntityType, TableExpressionBase)

Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source.
Select(IEntityType)

Creates a new SelectExpression which represents a SELECT in a SQL tree projecting an entity type from a table source created using default mapping in the model.
Select(SqlExpression)

Creates a new SelectExpression which represents a SELECT in a SQL tree projecting a SqlExpression or 1 from no table and without any composition.
Subtract(SqlExpression, SqlExpression, RelationalTypeMapping)

Creates a SqlExpression which represents a subtraction.

Applies to