Partager via

SqlExpressionFactory.Case Method

  • 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

Overloads

Case(SqlExpression, CaseWhenClause[])
Obsolete.

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

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

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, CaseWhenClause[])

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Caution

Use overload which takes IReadOnlyList instead of params

Creates a new CaseExpression which represent a CASE statement in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression operand, params Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] whenClauses);
[System.Obsolete("Use overload which takes IReadOnlyList instead of params")]
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression operand, params Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] whenClauses);
abstract member Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
override this.Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
[<System.Obsolete("Use overload which takes IReadOnlyList instead of params")>]
abstract member Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
override this.Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
Public Overridable Function Case (operand As SqlExpression, ParamArray whenClauses As CaseWhenClause()) As CaseExpression

Parameters

operand
SqlExpression

An expression to compare with Test in whenClauses.

whenClauses
CaseWhenClause[]

A list of CaseWhenClause to compare and get result from.

Returns

CaseExpression

An expression representing a CASE statement in a SQL tree.

Implements

Case(SqlExpression, CaseWhenClause[])
Attributes
ObsoleteAttribute

Applies to

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Creates a new CaseExpression which represent a CASE statement in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression elseResult);
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? elseResult);
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression Case (System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? elseResult);
abstract member Case : System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
override this.Case : System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
abstract member Case : System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
override this.Case : System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
Public Overridable Function Case (whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression) As CaseExpression
Public Overridable Function Case (whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression) As SqlExpression

Parameters

whenClauses
IReadOnlyList<CaseWhenClause>

A list of CaseWhenClause to evaluate condition and get result from.

elseResult
SqlExpression

A value to return if no whenClauses matches, if any.

Returns

CaseExpression
SqlExpression

An expression representing a CASE statement in a SQL tree.

Implements

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Applies to

Case(SqlExpression, SqlExpression, CaseWhenClause[])

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression operand, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression elseResult, params Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] whenClauses);
abstract member Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
override this.Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
Public Overridable Function Case (operand As SqlExpression, elseResult As SqlExpression, ParamArray whenClauses As CaseWhenClause()) As CaseExpression

Parameters

operand
SqlExpression
elseResult
SqlExpression
whenClauses
CaseWhenClause[]

Returns

CaseExpression

Applies to

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs
Source:
SqlExpressionFactory.cs

Creates a new CaseExpression which represent a CASE statement in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression operand, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression elseResult);
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? operand, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? elseResult);
abstract member Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
override this.Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression
Public Overridable Function Case (operand As SqlExpression, whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression) As CaseExpression

Parameters

operand
SqlExpression

An expression to compare with Test in whenClauses.

whenClauses
IReadOnlyList<CaseWhenClause>

A list of CaseWhenClause to compare and get result from.

elseResult
SqlExpression

A value to return if no whenClauses matches, if any.

Returns

CaseExpression

An expression representing a CASE statement in a SQL tree.

Implements

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Applies to

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression, SqlExpression)

Source:
SqlExpressionFactory.cs

Creates a new CaseExpression which represent a CASE statement in a SQL tree.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression Case (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? operand, System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? elseResult, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? existingExpression = default);
abstract member Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
override this.Case : Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
Public Overridable Function Case (operand As SqlExpression, whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression, Optional existingExpression As SqlExpression = Nothing) As SqlExpression

Parameters

operand
SqlExpression

An expression to compare with Test in whenClauses.

whenClauses
IReadOnlyList<CaseWhenClause>

A list of CaseWhenClause to compare or evaluate and get result from.

elseResult
SqlExpression

A value to return if no whenClauses matches, if any.

existingExpression
SqlExpression

An optional expression that can be re-used if it matches the new expression.

Returns

SqlExpression

An expression representing a CASE statement in a SQL tree.

Implements

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression, SqlExpression)

Applies to