共用方式為


ISqlExpressionFactory Interface

Definition

A factory for creating SqlExpression instances.

public interface ISqlExpressionFactory
type ISqlExpressionFactory = interface
Public Interface ISqlExpressionFactory
Derived

Remarks

The service lifetime is Scoped. This means that each DbContext instance will use its own instance of this service. The implementation may depend on other services registered with any lifetime. The implementation does not need to be thread-safe.

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.

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