SqlExpressionFactory.Coalesce Method

Definition

Creates a SqlExpression which represents a COALESCE operation.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlBinaryExpression Coalesce (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression left, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression right, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Coalesce (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression left, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression right, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping typeMapping = default);
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression Coalesce (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression left, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression right, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression Coalesce (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression left, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression right, Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping? typeMapping = default);
abstract member Coalesce : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlBinaryExpression
override this.Coalesce : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlBinaryExpression
abstract member Coalesce : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression
override this.Coalesce : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlFunctionExpression
abstract member Coalesce : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
override this.Coalesce : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Storage.RelationalTypeMapping -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
Public Overridable Function Coalesce (left As SqlExpression, right As SqlExpression, Optional typeMapping As RelationalTypeMapping = Nothing) As SqlBinaryExpression
Public Overridable Function Coalesce (left As SqlExpression, right As SqlExpression, Optional typeMapping As RelationalTypeMapping = Nothing) As SqlFunctionExpression
Public Overridable Function Coalesce (left As SqlExpression, right As SqlExpression, Optional typeMapping As RelationalTypeMapping = Nothing) As SqlExpression

Parameters

left
SqlExpression

The left operand.

right
SqlExpression

The right operand.

typeMapping
RelationalTypeMapping

A type mapping to be assigned to the created expression.

Returns

An expression representing a SQL COALESCE operation.

Implements

Applies to