SqlExpressionFactory.Case 메서드
정의
중요
일부 정보는 릴리스되기 전에 상당 부분 수정될 수 있는 시험판 제품과 관련이 있습니다. Microsoft는 여기에 제공된 정보에 대해 어떠한 명시적이거나 묵시적인 보증도 하지 않습니다.
오버로드
| 속성 | Description |
|---|---|
| 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, IReadOnlyList<CaseWhenClause>, SqlExpression, SqlExpression) |
SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 문을 만듭니다. |
Case(SqlExpression, CaseWhenClause[])
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
주의
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
에서 whenClauses비교할 식입니다Test.
- whenClauses
- CaseWhenClause[]
결과를 비교하고 가져올 목록 CaseWhenClause 입니다.
반품
SQL 트리의 CASE 문을 나타내는 식입니다.
구현
- 특성
적용 대상
Case(IReadOnlyList<CaseWhenClause>, SqlExpression)
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 문을 만듭니다.
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
매개 변수
- whenClauses
- IReadOnlyList<CaseWhenClause>
조건을 평가하고 결과를 가져올 목록 CaseWhenClause 입니다.
- elseResult
- SqlExpression
일치하는 항목이 없 whenClauses 으면 반환할 값입니다(있는 경우).
반품
SQL 트리의 CASE 문을 나타내는 식입니다.
구현
적용 대상
Case(SqlExpression, SqlExpression, CaseWhenClause[])
- Source:
- SqlExpressionFactory.cs
- Source:
- 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
매개 변수
- operand
- SqlExpression
- elseResult
- SqlExpression
- whenClauses
- CaseWhenClause[]
반품
적용 대상
Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
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
에서 whenClauses비교할 식입니다Test.
- whenClauses
- IReadOnlyList<CaseWhenClause>
결과를 비교하고 가져올 목록 CaseWhenClause 입니다.
- elseResult
- SqlExpression
일치하는 항목이 없 whenClauses 으면 반환할 값입니다(있는 경우).
반품
SQL 트리의 CASE 문을 나타내는 식입니다.
구현
적용 대상
Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression, SqlExpression)
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
SQL 트리에서 CASE 문을 나타내는 새 CaseExpression 문을 만듭니다.
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
매개 변수
- operand
- SqlExpression
에서 whenClauses비교할 식입니다Test.
- whenClauses
- IReadOnlyList<CaseWhenClause>
결과를 비교하거나 평가하고 가져올 목록 CaseWhenClause 입니다.
- elseResult
- SqlExpression
일치하는 항목이 없 whenClauses 으면 반환할 값입니다(있는 경우).
- existingExpression
- SqlExpression
새 식과 일치하는 경우 다시 사용할 수 있는 선택적 식입니다.
반품
SQL 트리의 CASE 문을 나타내는 식입니다.