/// <summary>
/// Renders a CaseTerm
/// </summary>
/// <param name="builder"></param>
/// <param name="term"></param>
protected virtual void CaseTerm(StringBuilder builder, CaseTerm term)
{
builder.Append(" when ");
WhereClause(builder, term.Condition);
builder.Append(" then ");
Expression(builder, term.Value);
}
SqlExpression PivotCaseExpression(PivotColumn col, PivotColumnValue val)
{
CaseClause caseClause = new CaseClause();
caseClause.ElseValue = SqlExpression.Null();
CaseTerm term = new CaseTerm(PivotCaseCondition(col, val), SqlExpression.Field(valueField));
caseClause.Terms.Add(term);
return(SqlExpression.Case(caseClause));
}
