如何在具有多个表的linq中使用join并使用orderby？

using System;
using System.Linq;

// 定义一个示例的数据模型类
class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
}

class Order
{
    public int Id { get; set; }
    public int CustomerId { get; set; }
    public string Product { get; set; }
    public decimal Price { get; set; }
}

class Program
{
    static void Main()
    {
        // 创建示例数据集合
        var customers = new[]
        {
            new Customer { Id = 1, Name = "John" },
            new Customer { Id = 2, Name = "Alice" },
            new Customer { Id = 3, Name = "Bob" }
        };

        var orders = new[]
        {
            new Order { Id = 1, CustomerId = 1, Product = "Apple", Price = 1.2m },
            new Order { Id = 2, CustomerId = 2, Product = "Banana", Price = 0.8m },
            new Order { Id = 3, CustomerId = 3, Product = "Orange", Price = 1.5m },
            new Order { Id = 4, CustomerId = 1, Product = "Grapes", Price = 2.3m }
        };

        // 执行 LINQ 查询
        var query = from customer in customers
                    join order in orders on customer.Id equals order.CustomerId
                    orderby order.Price descending
                    select new { customer.Name, order.Product, order.Price };

        // 遍历查询结果并输出
        foreach (var result in query)
        {
            Console.WriteLine($"{result.Name} bought {result.Product} for {result.Price}");
        }
    }
}