使用linq to sql从多个表中选择

var query = from customer in dbContext.Customers
            join order in dbContext.Orders on customer.CustomerId equals order.CustomerId
            where customer.City == "New York"
            select new
            {
                customer.CustomerId,
                customer.Name,
                order.OrderId,
                order.OrderDate
            };

var query = dbContext.Customers
            .Join(dbContext.Orders, customer => customer.CustomerId, order => order.CustomerId, (customer, order) => new { customer, order })
            .Where(x => x.customer.City == "New York")
            .Select(x => new
            {
                x.customer.CustomerId,
                x.customer.Name,
                x.order.OrderId,
                x.order.OrderDate
            });