SqlExpressionFactory.Case Yöntem

Tanım

Ad Alanı:: Microsoft.EntityFrameworkCore.Query

Bütünleştirilmiş Kod:: 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 v10.0.0

Paket:: Microsoft.EntityFrameworkCore.Relational v11.0.0

Paket:: Microsoft.EntityFrameworkCore.Relational v7.0.0

Paket:: Microsoft.EntityFrameworkCore.Relational v8.0.0

Paket:: Microsoft.EntityFrameworkCore.Relational v9.0.0

Önemli

Bazı bilgiler ürünün ön sürümüyle ilgilidir ve sürüm öncesinde önemli değişiklikler yapılmış olabilir. Burada verilen bilgilerle ilgili olarak Microsoft açık veya zımni hiçbir garanti vermez.

Aşırı Yüklemeler

Veri Akışı Adı	Description
Case(SqlExpression, CaseWhenClause[])	Geçersiz. SQL ağacındaki CASE deyimini temsil eden yeni CaseExpression bir oluşturur.
Case(IReadOnlyList<CaseWhenClause>, SqlExpression)	SQL ağacındaki CASE deyimini temsil eden yeni CaseExpression bir oluşturur.
Case(SqlExpression, SqlExpression, CaseWhenClause[])
Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)	SQL ağacındaki CASE deyimini temsil eden yeni CaseExpression bir oluşturur.
Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression, SqlExpression)	SQL ağacındaki CASE deyimini temsil eden yeni CaseExpression bir oluşturur.

Case(SqlExpression, CaseWhenClause[])

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Dikkat

Use overload which takes IReadOnlyList instead of params

SQL ağacındaki CASE deyimini temsil eden yeni CaseExpression bir oluşturur.

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

Parametreler

operand: SqlExpression

içinde whenClauseskarşılaştıracak Test bir ifade.

whenClauses: CaseWhenClause[]

Karşılaştırılıp elde edilen sonucun listesi CaseWhenClause .

Döndürülenler

CaseExpression

SQL ağacında case deyimini temsil eden ifade.

Uygulamalar

Case(SqlExpression, CaseWhenClause[])

Özellikler: ObsoleteAttribute

Şunlara uygulanır

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

SQL ağacındaki CASE deyimini temsil eden yeni CaseExpression bir oluşturur.

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

Parametreler

whenClauses: IReadOnlyList<CaseWhenClause>

Koşulu değerlendirmek ve sonucu almak için bir liste CaseWhenClause .

elseResult: SqlExpression

Eşleşme yoksa whenClauses döndürülecek bir değer (varsa).

Döndürülenler

SqlExpression

CaseExpression

SQL ağacında case deyimini temsil eden ifade.

Uygulamalar

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Şunlara uygulanır

Case(SqlExpression, SqlExpression, CaseWhenClause[])

Kaynak:: SqlExpressionFactory.cs

Kaynak:: 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

Parametreler

operand: SqlExpression

elseResult: SqlExpression

whenClauses: CaseWhenClause[]

Döndürülenler

CaseExpression

Şunlara uygulanır

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

SQL ağacındaki CASE deyimini temsil eden yeni CaseExpression bir oluşturur.

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

Parametreler

operand: SqlExpression

içinde whenClauseskarşılaştıracak Test bir ifade.

whenClauses: IReadOnlyList<CaseWhenClause>

Karşılaştırılıp elde edilen sonucun listesi CaseWhenClause .

elseResult: SqlExpression

Eşleşme yoksa whenClauses döndürülecek bir değer (varsa).

Döndürülenler

CaseExpression

SQL ağacında case deyimini temsil eden ifade.

Uygulamalar

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Şunlara uygulanır

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

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

Kaynak:: SqlExpressionFactory.cs

SQL ağacındaki CASE deyimini temsil eden yeni CaseExpression bir oluşturur.

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

Parametreler

operand: SqlExpression

içinde whenClauseskarşılaştıracak Test bir ifade.

whenClauses: IReadOnlyList<CaseWhenClause>

Karşılaştırılıp değerlendirilecek ve sonuç alınacak bir liste CaseWhenClause .

elseResult: SqlExpression

Eşleşme yoksa whenClauses döndürülecek bir değer (varsa).

existingExpression: SqlExpression

Yeni ifadeyle eşleşiyorsa yeniden kullanılabilecek isteğe bağlı bir ifade.

Döndürülenler

SqlExpression

SQL ağacında case deyimini temsil eden ifade.

Uygulamalar

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

Şunlara uygulanır

Geri Bildirim

Bu sayfayı yararlı buldunuz mu?