c# - Que Sera, Sera! Net Framework 4.0 是否支持 SQL 2008？

Question

我做了大量工作来开发 CLR 例程以使用 VS2010 实现 DAL 功能，打算将它们移植到 SQL2008R2 clr 程序集；做了单元测试，一切似乎都很好..然后到了将它们放入 SQL CLR 程序集的日子。las!，SQL2008 只支持框架 3.5 以下的程序集!花在采用 c# 4.0 功能上的日子，现在必须扔掉并滑回 c#2.0。又过了几天。

我可以将 Framework 4 CLR 程序集与 SQL2010 一起使用吗？

SQL2008R2会支持framework 4.0吗？如果是，什么时候？

Answer 1

Will there be support for framework 4.0 support in SQL2008R2 ? if so when ?

http://software.intel.com/en-us/blogs/2009/10/16/sql-server-2008-sqlclr-net-framework-version/

SQL Server 2008 and the forthcoming SQL Server 2008 R2 release, previously codenamed "Kilimanjaro", will both continue to load the latest service release of the version 2.0 CLR.

You might be wondering, what is the rationale behind SQL Server continuing to load version 2.0 of the CLR? Is it merely a healthy cautious attitude so existing UDT's, UDA's, etc. are not broken; or is it because additional engineering would be required to support the new CLR?

It seems the answer is actually a little of both.

With the .net framework 4.0 we now have the ability to load two or more distinct versions of the CLR within a single process. In previous releases of the .net framework, a process could only load a single instance of the CLR. Given this restriction the CLR team recommended that hosts, such as SQL Server, use the LockClrVersion function to determine the version of the CLR to load prior to initialization. So, as stated previously, SQL Server 2008 and SQL Server 2008 R2 will continue to load the latest service release of the version 2.0 CLR as the version is locked before initialization of the CLR begins.

While future versions of SQL Server may load newer versions of the CLR, or even support the loading of multiple CLR's within the process, version 2.0 of the CLR is here to stay for SQLCLR within SQL Server 2008 and SQL Server 2008 R2.

此外，a little bit more here .