2)  UPDATE A PRODUCT IN THE DATABASE
The code below demonstrates how to retrieve a single product from the database, update its price, and then save the changes back to the database:

Note: VB in the Orcas Beta 1 doesn't support Lambdas yet. It will, though, in Beta 2 when the query above can be rewritten to be more concise.

3)  INSERT A NEW CATEGORY & TWO NEW PRODUCTS INTO THE DATABASE
The code below demonstrates how to create a new category, and then create two new products and associate them with the category. All three are then saved in the database.

Note below how I don't need to manually manage the primary key/foreign key relationships. Instead, just by adding the Product objects into the category's "Products" collection, and then by adding the Category object into the DataContext's "Categories" collection, LINQ-to-SQL will know to persist the appropriate PK/FK relationships for me automatically.