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

// Update Betty's color to light pink.

var betty = (from c in ctx.Inventories

where c.PetName == "Betty"

select c).First();

betty.Color = "Green";

ctx.SubmitChanges();

}

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

856

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

---

Deleting Existing Items

And finally, if you wish to delete an item from the relational database table, simply build a LINQ

query to locate the item you are no longer interested in, and remove it from the correct Table

member variable of the DataContext using the DeleteOnSubmit() method. Once you have done so,

again call SubmitChanges():

static void DeleteCar(AutoLotObjectsDataContext ctx)

{

int carToDelete = 0;

Console.Write("Enter ID of car to delete: ");

carToDelete = int.Parse(Console.ReadLine());