如何在Entity Framework中查找其他表中的值

public class Order
{
    public int OrderId { get; set; }
    public int CustomerId { get; set; }
    public Customer Customer { get; set; }
    // 其他属性...
}

public class Customer
{
    public int CustomerId { get; set; }
    public string Name { get; set; }
    // 其他属性...
}

using (var context = new YourDbContext())
{
    var order = context.Orders.FirstOrDefault(o => o.OrderId == orderId);
    if (order != null)
    {
        string customerName = order.Customer.Name;
        // 其他操作...
    }
}

using (var context = new YourDbContext())
{
    var query = from order in context.Orders
                join product in context.Products on order.OrderId equals product.OrderId
                where order.OrderId == orderId
                select product.Name;

    var productNames = query.ToList();
    // 其他操作...
}