Bahasa

SqlExpressionFactory.Case Metode

Definisi

Overload

Nama Deskripsi
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, IReadOnlyList<CaseWhenClause>, SqlExpression, SqlExpression)

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

Case(SqlExpression, CaseWhenClause[])

Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs

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.

Mengembalikan

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Penerapan

Atribut

Berlaku untuk

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression 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.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.SqlExpression
override this.Case : System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> * Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression -> Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression
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 SqlExpression
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

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Penerapan

Berlaku untuk

Case(SqlExpression, SqlExpression, CaseWhenClause[])

Sumber:
SqlExpressionFactory.cs
Sumber:
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

Parameter

operand
SqlExpression
elseResult
SqlExpression
whenClauses
CaseWhenClause[]

Mengembalikan

Berlaku untuk

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs

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.

elseResult
SqlExpression

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

Mengembalikan

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Penerapan

Berlaku untuk

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

Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs
Sumber:
SqlExpressionFactory.cs

Membuat baru CaseExpression yang mewakili pernyataan CASE di pohon SQL.

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

Parameter

operand
SqlExpression

Ekspresi untuk dibandingkan dengan Test di whenClauses.

whenClauses
IReadOnlyList<CaseWhenClause>

Daftar CaseWhenClause untuk membandingkan atau mengevaluasi dan mendapatkan hasilnya.

elseResult
SqlExpression

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

existingExpression
SqlExpression

Ekspresi opsional yang dapat digunakan kembali jika cocok dengan ekspresi baru.

Mengembalikan

Ekspresi yang mewakili pernyataan CASE di pohon SQL.

Penerapan

Berlaku untuk