static string OrderByItemStr(OrderByExpr orderBy, SqlExprParams pars) { return ($"{SqlExpression.ExprToSql(orderBy.Expr.Body, pars.ReplaceSelectParams(orderBy.Expr.Parameters[0], null), true)} " + $"{(orderBy.Order == OrderByOrder.Asc ? "ASC" : orderBy.Order == OrderByOrder.Desc ? "DESC" : throw new ArgumentException())}" + $"{(orderBy.Nulls == OrderByNulls.NullsFirst ? " NULLS FIRST" : orderBy.Nulls == OrderByNulls.NullsLast ? " NULLS LAST" : "")}"); }
public static IQueryOrderBy Field(Type type, string field, QueryOrderType orderType) { var expressionOrderBy = (AbstractExpressionOrderBy)_factory.CreateOrderBy(QueryOrderByExpressionType.Expression); expressionOrderBy.Expr = OrderByExpr.Build().Field(type, field); expressionOrderBy.OrderType = orderType; return(expressionOrderBy); }