Bagikan melalui


ISqlExpressionFactory.Case Metode

Definisi

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, 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 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 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
[<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
Public 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

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Atribut

Berlaku untuk

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

public Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression elseResult);
public 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
Public 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

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Berlaku untuk

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

public 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 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
Public 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

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Berlaku untuk