C# 3.0 language enhancements in action

While browsing the MSDN site, I ran into this lab that provides a surprisingly detailled hands-on experience with C# 3.0 and LINQ. I read the article, and as far as I understand it, the major features of C# 3.0 include the ability to write less code for the same constructs, and an abstract query language that may potentially elliminate SQL.
Well, you can't blame Microsoft for being slow.... Visual Studio 2005 is not even released yet...