Bagikan melalui

SqlExpressionFactory.Case Metode

  • Referensi

Definisi

Ruang nama:
Microsoft.EntityFrameworkCore.Query
Rakitan:
Microsoft.EntityFrameworkCore.Relational.dll
Paket:
Microsoft.EntityFrameworkCore.Relational v3.0.0
Paket:
Microsoft.EntityFrameworkCore.Relational v3.1.0
Paket:
Microsoft.EntityFrameworkCore.Relational v5.0.0
Paket:
Microsoft.EntityFrameworkCore.Relational v6.0.0
Paket:
Microsoft.EntityFrameworkCore.Relational v7.0.0
Paket:
Microsoft.EntityFrameworkCore.Relational v8.0.0

Overload

Case(SqlExpression, CaseWhenClause[])
Kedaluwarsa.

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.
Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.
Case(SqlExpression, SqlExpression, CaseWhenClause[])
Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

Case(SqlExpression, CaseWhenClause[])

Perhatian

Use overload which takes IReadOnlyList instead of params

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

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

Parameter

operand
SqlExpression

Ekspresi untuk dibandingkan dengan Test di whenClauses.

whenClauses
CaseWhenClause[]

Daftar CaseWhenClause untuk membandingkan dan mendapatkan hasil dari.

Mengembalikan

CaseExpression

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Penerapan

Case(SqlExpression, CaseWhenClause[])
Atribut
ObsoleteAttribute

Berlaku untuk

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

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);
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
Public Overridable Function Case (whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression) As CaseExpression

Parameter

whenClauses
IReadOnlyList<CaseWhenClause>

Daftar CaseWhenClause untuk mengevaluasi kondisi dan mendapatkan hasilnya.

elseResult
SqlExpression

Nilai yang akan dikembalikan jika tidak ada whenClauses yang cocok, jika ada.

Mengembalikan

CaseExpression

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Penerapan

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Berlaku untuk

Case(SqlExpression, SqlExpression, CaseWhenClause[]) 

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

Parameter

operand
SqlExpression
elseResult
SqlExpression
whenClauses
CaseWhenClause[]

Mengembalikan

CaseExpression

Berlaku untuk

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

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

Parameter

operand
SqlExpression

Ekspresi untuk dibandingkan dengan Test di whenClauses.

whenClauses
IReadOnlyList<CaseWhenClause>

Daftar CaseWhenClause untuk membandingkan dan mendapatkan hasil dari.

elseResult
SqlExpression

Nilai yang akan dikembalikan jika tidak ada whenClauses yang cocok, jika ada.

Mengembalikan

CaseExpression

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Penerapan

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Berlaku untuk