SqlExpressionFactory.Case 메서드

참조

정의

네임스페이스:: Microsoft.EntityFrameworkCore.Query

어셈블리:: Microsoft.EntityFrameworkCore.Relational.dll

패키지:: Microsoft.EntityFrameworkCore.Relational v3.0.0

패키지:: Microsoft.EntityFrameworkCore.Relational v3.1.0

패키지:: Microsoft.EntityFrameworkCore.Relational v5.0.0

패키지:: Microsoft.EntityFrameworkCore.Relational v6.0.0

패키지:: Microsoft.EntityFrameworkCore.Relational v7.0.0

패키지:: Microsoft.EntityFrameworkCore.Relational v8.0.0

중요

일부 정보는 릴리스되기 전에 상당 부분 수정될 수 있는 시험판 제품과 관련이 있습니다. Microsoft는 여기에 제공된 정보에 대해 어떠한 명시적이거나 묵시적인 보증도 하지 않습니다.

오버로드

Case(SqlExpression, CaseWhenClause[])	사용되지 않음. SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 를 만듭니다.
Case(IReadOnlyList<CaseWhenClause>, SqlExpression)	SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 를 만듭니다.
Case(SqlExpression, SqlExpression, CaseWhenClause[])
Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)	SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 를 만듭니다.

Case(SqlExpression, CaseWhenClause[])

주의

Use overload which takes IReadOnlyList instead of params

SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 를 만듭니다.

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

매개 변수

operand: SqlExpression

에서 비교할 식입니다 TestwhenClauses.

whenClauses: CaseWhenClause[]

결과를 비교하고 가져올 목록 CaseWhenClause 입니다.

반환

CaseExpression

SQL 트리의 CASE 문을 나타내는 식입니다.

구현

Case(SqlExpression, CaseWhenClause[])

특성: ObsoleteAttribute

적용 대상

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 를 만듭니다.

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

매개 변수

whenClauses: IReadOnlyList<CaseWhenClause>

조건을 평가하고 결과를 가져올 목록 CaseWhenClause 입니다.

elseResult: SqlExpression

일치하는 항목이 없 whenClauses 으면 반환할 값입니다(있는 경우).

반환

CaseExpression

SQL 트리의 CASE 문을 나타내는 식입니다.

구현

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

적용 대상

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

매개 변수

operand: SqlExpression

elseResult: SqlExpression

whenClauses: CaseWhenClause[]

반환

CaseExpression

적용 대상

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 를 만듭니다.

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

매개 변수

operand: SqlExpression

에서 비교할 식입니다 TestwhenClauses.

whenClauses: IReadOnlyList<CaseWhenClause>

결과를 비교하고 가져올 목록 CaseWhenClause 입니다.

elseResult: SqlExpression

일치하는 항목이 없 whenClauses 으면 반환할 값입니다(있는 경우).

반환

CaseExpression

SQL 트리의 CASE 문을 나타내는 식입니다.

구현

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

적용 대상

다음을 통해 공유

SqlExpressionFactory.Case 메서드

정의

오버로드

Case(SqlExpression, CaseWhenClause[])

매개 변수

반환

구현

적용 대상

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

매개 변수

반환

구현

적용 대상

Case(SqlExpression, SqlExpression, CaseWhenClause[])

매개 변수

반환

적용 대상

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

매개 변수

반환

구현

적용 대상

추가 리소스