对LINQ C#的SQL查询[连接多个表]

var query = from customer in customers
            join order in orders on customer.CustomerID equals order.CustomerID
            join product in products on order.ProductID equals product.ProductID
            select new
            {
                CustomerName = customer.CustomerName,
                OrderDate = order.OrderDate,
                ProductName = product.ProductName
            };

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