LINQ to SQL: Querying the Database

I know everyone is excited, so I be a bit more critic to this video podcast.

1. IMHO it is too short and too fast to the point. Not touching  it more deeply, i.e. why we are extending DataContext class instead of building our own factory, or it gets to the ExecuteCommand method just in the end of the video and then it immediately finish.

2. Would be better if Scott first of all told something about advantages/disadvantages of using SQL instead of LINQ (just a quick info and guide where to look for LINQ generated SQL statements), and touch in a bit more detail the ExecuteCommand method.

3. when will you support the "new" iPod Touch screen resolution in podcasts? It isn't much of a enjoyable experience watching them in present low-resolution state.

Thank you

Its Great that Microsoft offers world's smallest tutorials for their new products! Hats off to you. :(

Well kinda fast yet nice :)

Fulltext Search I need to use pass through SQL to LINQ

Are there some exemples how to do it??

Just would like to point out a couple of errors in the code:

In part9.aspx, line 31:

Product p = db.Products.Single(p => p.ProductName == "Foo");

You can't declare a local variable "p" in the lambda expression here, because "p" is already used to denote the Product. You could change it to something else, like:

Product p = db.Products.Single(prod => prod.ProductName == "Foo");

In Helpers.cs, line 57:

return ExecuteCommand("delete from products where ProductId={0}", instance.ProductID);

DeleteProduct is a void method, so it can't return anything.  You need to get rid of the "return" keyword.