使用实体框架的两个表之间的Sql连接-尝试从两个表绑定Gridview数据

public class Order
{
    public int OrderId { get; set; }
    public string OrderName { get; set; }
    public int CustomerId { get; set; }

    public virtual Customer Customer { get; set; }
}

public class Customer
{
    public int CustomerId { get; set; }
    public string CustomerName { get; set; }

    public virtual ICollection<Order> Orders { get; set; }
}

public class YourDbContext : DbContext
{
    public DbSet<Order> Orders { get; set; }
    public DbSet<Customer> Customers { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Order>()
            .HasRequired(o => o.Customer)
            .WithMany(c => c.Orders)
            .HasForeignKey(o => o.CustomerId);

        base.OnModelCreating(modelBuilder);
    }
}

using (var context = new YourDbContext())
{
    var query = from order in context.Orders
                join customer in context.Customers on order.CustomerId equals customer.CustomerId
                select new
                {
                    OrderId = order.OrderId,
                    OrderName = order.OrderName,
                    CustomerName = customer.CustomerName
                };

    GridView1.DataSource = query.ToList();
    GridView1.DataBind();
}