Compartir a través de

Conditionals (M to SQL Mapping)

  • Artículo

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

Conditional expressions are translated as follows.

Operator “M” Example SQL Example

Conditional

A ? B : C

Not currently implemented.

Coalesce

A ?? B

 
case
   when A is null then B
   else A
end

Exceptions

Entity types: The coalesce operator does not support entity types.

Collection types: Collection types cannot be null and cannot be used in the coalesce operator.