如何从两个表中获取数据，但在第二个(外键)表上使用where子句？[LINQ]

// 定义Customers表的数据源
List<Customer> customers = new List<Customer>
{
    new Customer { Id = 1, Name = "Alice" },
    new Customer { Id = 2, Name = "Bob" },
    new Customer { Id = 3, Name = "Charlie" }
};

// 定义Orders表的数据源
List<Order> orders = new List<Order>
{
    new Order { Id = 1, CustomerId = 1, Product = "Product A" },
    new Order { Id = 2, CustomerId = 2, Product = "Product B" },
    new Order { Id = 3, CustomerId = 1, Product = "Product C" },
    new Order { Id = 4, CustomerId = 3, Product = "Product A" }
};

var query = from customer in customers
            join order in orders on customer.Id equals order.CustomerId
            where order.Product == "Product A"
            select new
            {
                CustomerName = customer.Name,
                OrderProduct = order.Product
            };

foreach (var result in query)
{
    Console.WriteLine($"Customer: {result.CustomerName}, Order: {result.OrderProduct}");
}