static void Listing13_2()
{
Console.WriteLine("{0} : Begin", new StackTrace(0, true).GetFrame(0).GetMethod().Name);
NorthwindDataContext db = new NorthwindDataContext();
IQueryable <Customer> custs = from c in db.Customers
where c.City == "London"
select c;
foreach (Customer c in custs)
{
Console.WriteLine("{0} has {1} orders.", c.CompanyName, c.Orders.Count);
}
Console.WriteLine("{0} : End", new StackTrace(0, true).GetFrame(0).GetMethod().Name);
}
static void Listing13_3()
{
Console.WriteLine("{0} : Begin", new StackTrace(0, true).GetFrame(0).GetMethod().Name);
NorthwindDataContext db = new NorthwindDataContext();
db.Log = Console.Out;
Customer cust =
new Customer
{
CustomerID = "EWICH",
CompanyName = "Every 'Wich Way",
ContactName = "Vickey Rattz",
ContactTitle = "Owner",
Address = "105 Chip Morrow Dr.",
City = "Alligator Point",
Region = "FL",
PostalCode = "32346",
Country = "USA",
Phone = "(800) EAT-WICH",
Fax = "(800) FAX-WICH"
};
db.Customers.InsertOnSubmit(cust);
db.SubmitChanges();
Customer customer = db.Customers.Where(c => c.CustomerID == "EWICH").First();
Console.WriteLine("{0} - {1}", customer.CompanyName, customer.ContactName);
// Restore the database.
db.Customers.DeleteOnSubmit(cust);
db.SubmitChanges();
Console.WriteLine("{0} : End", new StackTrace(0, true).GetFrame(0).GetMethod().Name);
}
