When
Adds a WHEN clause that compares the case value against a literal condition.
Return
A ValueCaseWhen instance for method chaining
Parameters
The literal value to compare against
The expression to return if the condition matches
Type Parameters
The return type of the result expression
Adds a WHEN clause that compares the case value against an expression condition.
Return
A ValueCaseWhen instance for method chaining
Parameters
The expression to compare against
The expression to return if the condition matches
Type Parameters
The return type of the result expression
Adds a WHEN clause that compares the case value against an expression condition with a literal result.
Return
A ValueCaseWhen instance for method chaining
Parameters
The expression to compare against
The literal value to return if the condition matches
Optional column type for the result value
Type Parameters
The return type of the result value
Adds a WHEN clause that compares the case value against a literal condition with a literal result.
Return
A ValueCaseWhen instance for method chaining
Parameters
The literal value to compare against
The literal value to return if the condition matches
Optional column type for the result value
Type Parameters
The return type of the result value