This print for content only-size & color not accurate 7" X 9-1/4" / casebound / malloy

// Create an AutoLotDatabase object.

AutoLotDatabase db = new AutoLotDatabase(cnStr);

// Note we can now use the Inventory field of AutoLotDatabase.

Console.WriteLine("-> Contents of Inventory Table from AutoLot database:\n");

foreach (var car in from c in db.Inventory select c)

Console.WriteLine(car.ToString());

Console.ReadLine();

}

One aspect of building a strongly typed data context that may surprise you is that the

DataContext-derived type (AutoLotDatabase in this example) does not directly create the Table

member variables and has no trace of the expected GetTable() method call. At runtime, however,

when you iterate over your LINQ result set, the DataContext will create the Table type transpar-

ently in the background.

C H A P T E R   2 4  

■

P R O G R A M M I N G   W I T H   T H E   L I N Q   A P I S

846

8849CH24.qxd  10/19/07  10:11 AM  Page 846

---

Of course, any LINQ query can be used to obtain a given result set. Assume we have authored

the following helper method that is called from Main() before exiting (note this method expects us

to pass in an AutoLotDatabase instance):

static void ShowOnlyBimmers(AutoLotDatabase db)

{

Console.WriteLine("***** Only BMWs *****\n");