SQL Server 2008 vs 2005 Linq integration

linqsql-server-2005sql-server-2008

Linq To SQL or Entity framework both integrate nicely with SQL Server 2005.

The SQL Server 2008 spec sheet promises even better integration – but I can't see it.

What are some examples of what you can do Linq-wise when talking to a 2008 server that you can't when talking to SQL Server 2005?

Best Answer

This marketing link claims

"Write data access code directly against a Microsoft SQL Server database, using LINQ to SQL."

Which is basically untrue.

Linq To SQL is query comprehension translated into expression trees translated into SQL, optimized by the query optimizer and then run against SQL Server database. "directly" feh.