NorthwindDataContext db = new NorthwindDataContext(ConnectionString);
string filterCustomerID = "QUICK";

var customerOrders =
from o in db.Orders
where o.CustomerID == filterCustomerID
select new {
o.OrderID,
o.OrderDate,
o.Freight,
o.ShipName,
o.ShipAddress,
o.ShipCity,
o.ShipCountry
};

var customerOrderDetails =
from od in db.Order_Details
join o in db.Orders
		on od.OrderID equals o.OrderID
join p in db.Products
		on od.ProductID equals p.ProductID
where o.CustomerID == filterCustomerID
select new {
od.UnitPrice,
od.Quantity,
od.Discount,
p.ProductName
};

DataSet ds = new DataSet("CustomerOrders");
ds.Tables.Add(customerOrders.CreateDataTable("Orders"));
ds.Tables.Add(customerOrderDetails.CreateDataTable("OrderDetails"));
