使用linq to entity通过一个查询按特定值搜索多个无关系的表

public class Customer
{
    public int Id { get; set; }
    public string Name { get; set; }
}

public class Order
{
    public int Id { get; set; }
    public int CustomerId { get; set; }
    public int ProductId { get; set; }
    public DateTime OrderDate { get; set; }
}

public class Product
{
    public int Id { get; set; }
    public string Name { get; set; }
}

using (var context = new YourDbContext())
{
    var query = from order in context.Orders
                join customer in context.Customers on order.CustomerId equals customer.Id
                join product in context.Products on order.ProductId equals product.Id
                where product.Name == "iPhone"
                select new
                {
                    CustomerName = customer.Name,
                    OrderDate = order.OrderDate
                };

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