public Query AddCase(string alias, object[] whenExpression, object[] thenExpression, object[] elseExpression) { var qc = new QueryColumn { Value = $"CASE WHEN {GetExpression(whenExpression)} THEN {GetExpression(thenExpression)} ELSE {GetExpression(elseExpression)} END", As = alias }; QueryColumns.Add(qc); return(this); }
public Query AddColumn(string alias, params object[] expressionParts) { var qc = new QueryColumn { Value = Expression.GetExpression(expressionParts, QueryElements), As = alias }; QueryColumns.Add(qc); return(this); }