SqlExpressionFactory.Case Method
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
| Case(SqlExpression, CaseWhenClause[]) |
Obsolete.
Creates a new CaseExpression which represent a CASE statement in a SQL tree. |
| Case(IReadOnlyList<CaseWhenClause>, SqlExpression) |
Creates a new CaseExpression which represent a CASE statement in a SQL tree. |
| Case(SqlExpression, SqlExpression, CaseWhenClause[]) | |
| Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression) |
Creates a new CaseExpression which represent a CASE statement in a SQL tree. |
| Case(SqlExpression, IReadOnlyList<CaseWhenClause>, SqlExpression, SqlExpression) |
Creates a new CaseExpression which represent a CASE statement in a SQL tree. |
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
Caution
Use overload which takes IReadOnlyList instead of params
Creates a new CaseExpression which represent a CASE statement in a SQL tree.
C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression operand, params Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause[] whenClauses);C#
[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.CaseExpressionPublic Overridable Function Case (operand As SqlExpression, ParamArray whenClauses As CaseWhenClause()) As CaseExpressionParameters
- operand
- SqlExpression
An expression to compare with Test in whenClauses.
- whenClauses
- CaseWhenClause[]
A list of CaseWhenClause to compare and get result from.
Returns
An expression representing a CASE statement in a SQL tree.
Implements
- Attributes
Applies to
Entity Framework Core 6.0 y otras versiones
| Producto | Versiones (Obsoleto) |
|---|---|
| Entity Framework Core | 3.0, 3.1 (5.0, 6.0) |
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
Creates a new CaseExpression which represent a CASE statement in a SQL tree.
C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression elseResult);C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseExpression Case (System.Collections.Generic.IReadOnlyList<Microsoft.EntityFrameworkCore.Query.SqlExpressions.CaseWhenClause> whenClauses, Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression? elseResult);C#
public virtual Microsoft.EntityFrameworkCore.Query.SqlExpressions.SqlExpression 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.CaseExpressionabstract 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.SqlExpressionPublic Overridable Function Case (whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression) As CaseExpressionPublic Overridable Function Case (whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression) As SqlExpressionParameters
- whenClauses
- IReadOnlyList<CaseWhenClause>
A list of CaseWhenClause to evaluate condition and get result from.
- elseResult
- SqlExpression
A value to return if no whenClauses matches, if any.
Returns
An expression representing a CASE statement in a SQL tree.
Implements
Applies to
Entity Framework Core 9.0 y otras versiones
| Producto | Versiones |
|---|---|
| Entity Framework Core | 3.0, 3.1, 5.0, 6.0, 7.0, 8.0, 9.0 |
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
C#
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.CaseExpressionPublic Overridable Function Case (operand As SqlExpression, elseResult As SqlExpression, ParamArray whenClauses As CaseWhenClause()) As CaseExpressionParameters
- operand
- SqlExpression
- elseResult
- SqlExpression
- whenClauses
- CaseWhenClause[]
Returns
Applies to
Entity Framework Core 3.1 y Entity Framework Core 3.0
| Producto | Versiones |
|---|---|
| Entity Framework Core | 3.0, 3.1 |
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
- Source:
- SqlExpressionFactory.cs
Creates a new CaseExpression which represent a CASE statement in a SQL tree.
C#
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);C#
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.CaseExpressionPublic Overridable Function Case (operand As SqlExpression, whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression) As CaseExpressionParameters
- operand
- SqlExpression
An expression to compare with Test in whenClauses.
- whenClauses
- IReadOnlyList<CaseWhenClause>
A list of CaseWhenClause to compare and get result from.
- elseResult
- SqlExpression
A value to return if no whenClauses matches, if any.
Returns
An expression representing a CASE statement in a SQL tree.
Implements
Applies to
Entity Framework Core 8.0 y otras versiones
| Producto | Versiones |
|---|---|
| Entity Framework Core | 5.0, 6.0, 7.0, 8.0 |
- Source:
- SqlExpressionFactory.cs
Creates a new CaseExpression which represent a CASE statement in a SQL tree.
C#
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.SqlExpressionPublic Overridable Function Case (operand As SqlExpression, whenClauses As IReadOnlyList(Of CaseWhenClause), elseResult As SqlExpression, Optional existingExpression As SqlExpression = Nothing) As SqlExpressionParameters
- operand
- SqlExpression
An expression to compare with Test in whenClauses.
- whenClauses
- IReadOnlyList<CaseWhenClause>
A list of CaseWhenClause to compare or evaluate and get result from.
- elseResult
- SqlExpression
A value to return if no whenClauses matches, if any.
- existingExpression
- SqlExpression
An optional expression that can be re-used if it matches the new expression.
Returns
An expression representing a CASE statement in a SQL tree.
Implements
Applies to
Entity Framework Core 9.0
| Producto | Versiones |
|---|---|
| Entity Framework Core | 9.0 |
Colaborar con nosotros en GitHub
El origen de este contenido se puede encontrar en GitHub, donde también puede crear y revisar problemas y solicitudes de incorporación de cambios. Para más información, consulte nuestra guía para colaboradores.
Comentarios de Entity Framework
Entity Framework es un proyecto de código abierto. Seleccione un vínculo para proporcionar comentarios: