SQL Server 2008 and .Net 4.0?

Question

Does anyone know whether I can load .net 4.0 assemblies from SQL Server 2008? In particular, we are looking at SQL Reporting, with Custom Data Extensions. I have noticed that SQL Server 2008 Business Intelligence Studio does not seem to support VS2010 at the moment. If I release my CDE's as .net 4.0 assemblies, will I even be able to load them from within the SQL Server Reporting Server?

Answer 1

This article on the SQL Server Express blog suggests there will be no .NET 4 SQLCLR in SQL Server 2008 (assuming that the logic extends to the other editions):

http://blogs.msdn.com/sqlexpress/archive/2009/12/09/sql-server-express-and-net-4.aspx.

i.e. it would break backwards compatibility because the SQL Server Engine can only host one version of the CLR.