언어

ISqlExpressionFactory.Case 메서드

정의

오버로드

속성 Description
Case(SqlExpression, CaseWhenClause[])
사용되지 않음.

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

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

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

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

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

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

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

Case(SqlExpression, CaseWhenClause[])

주의

Use overload which takes IReadOnlyList instead of params

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

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

매개 변수

operand
SqlExpression

에서 whenClauses비교할 식입니다Test.

whenClauses
CaseWhenClause[]

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

반품

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

특성

적용 대상

Case(IReadOnlyList<CaseWhenClause>, SqlExpression)

Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs

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

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

매개 변수

whenClauses
IReadOnlyList<CaseWhenClause>

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

elseResult
SqlExpression

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

반품

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

적용 대상

Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression)

Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs

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

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

매개 변수

operand
SqlExpression

에서 whenClauses비교할 식입니다Test.

whenClauses
IReadOnlyList<CaseWhenClause>

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

elseResult
SqlExpression

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

반품

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

적용 대상

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

Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs
Source:
ISqlExpressionFactory.cs

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

public 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
Public 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 문을 나타내는 식입니다.

적용 대상