/// <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)); }