更改/替换查询OrderBy字段的ExpressionTree ExpressionVisitor

public class OrderByFieldVisitor : ExpressionVisitor
{
    private readonly string _oldFieldName;
    private readonly string _newFieldName;

    public OrderByFieldVisitor(string oldFieldName, string newFieldName)
    {
        _oldFieldName = oldFieldName;
        _newFieldName = newFieldName;
    }

    protected override Expression VisitMember(MemberExpression node)
    {
        if (node.Member.Name == _oldFieldName)
        {
            var newMember = typeof(YourEntityClass).GetMember(_newFieldName).FirstOrDefault();
            if (newMember != null)
            {
                return Expression.MakeMemberAccess(node.Expression, newMember);
            }
        }
        return base.VisitMember(node);
    }
}

// 使用示例
var query = yourDataContext.YourEntities.OrderBy(e => e.FieldName);

var visitor = new OrderByFieldVisitor("FieldName", "NewFieldName");
var newQuery = visitor.VisitAndConvert(query.Expression, "VisitOrderByField");
var newOrderByExpression = (Expression<Func<YourEntityClass, object>>)newQuery;

var result = yourDataContext.YourEntities.OrderBy(newOrderByExpression);