如何使用Linq to Sql填充复杂对象

// 创建数据库上下文
using (var context = new MyDataContext())
{
    // 查询数据
    var query = from c in context.Customers
                join o in context.Orders on c.CustomerID equals o.CustomerID
                where c.City == "New York"
                select new CustomerOrder
                {
                    CustomerName = c.Name,
                    OrderID = o.OrderID,
                    OrderDate = o.OrderDate
                };

    // 执行查询并填充对象
    List<CustomerOrder> customerOrders = query.ToList();
}

// 定义实体类
public class Customer
{
    public string CustomerID { get; set; }
    public string Name { get; set; }
    public string City { get; set; }
}

public class Order
{
    public int OrderID { get; set; }
    public string CustomerID { get; set; }
    public DateTime OrderDate { get; set; }
}

// 定义复杂对象
public class CustomerOrder
{
    public string CustomerName { get; set; }
    public int OrderID { get; set; }
    public DateTime OrderDate { get; set; }
}