我有一个订单列表，它有一个int类型的属性“Status”。对于每个状态，我都有不同语言的翻译。我想按选定的翻译而不是按数字状态值对列表进行排序。这里的最佳做法是什么？

public record OrderTranslation
{
    public string   OrderStatus       { get; set; }
    public string   StatusDescription { get; set; }
    public Language Language          { get; set; }
}
    
public record Order 
{
    public int? Id     { get; set; }
    public int  Status { get; set; }
        
    // I have added a new value to set the translated value and I want to order by this
    public string TranslatedStatusValue { get; set;}
}

我职责：

public async Task<FilterResult> FilterAsync(FilterRequest filterRequest, List<string> filterProperties, Language selectedLanguage)
{
    var orderTranslations = dataContext
        .OrderTranslations
        .Where(ot => ot.Language == selectedLanguage)
        .ToList();
    
    var orders = dataContext.Orders.AsNoTracking();
    
    foreach (var order in orders)
    {
        var description = orderTranslations
            .Single(x => x.OrderStatus == serviceContract.Status)
            .StatusDescription;

        serviceContract.TranslatedValue = description;
    }

    // The TranslatedValue is always empty here
    // This is not working, but I want to Order by the translation. Is there another possibility to to this, not using an extra property?
    IQueryable<ServiceContractOrder> query = orders
        .OrderBy("TranslatedStatusValue", filterRequest.IsSortAscending)
        .WhereMatchesFilter(filterRequest, filterProperties);
                             
    result.FilterHits = await query
        .Skip(filterRequest.ItemsToSkip())
        .Take(filterRequest.ItemsPerPage)
        .Cast<object>()
        .ToListAsync();

    result.TotalCount = await query.CountAsync();
    result.ObjectType = typeof(Order).AssemblyQualifiedName;
    result.FilteredProperties = filterProperties;
}