With the release of Visual Studio 2008 and .Net Framework 3.5 SP1, LINQ to SQL now supports some of the new features in SQL Server 2008.
Enjoy!