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