Search code examples
sql-serversqlclr

.Net Core assemblies in SQL CLR

Can .Net Core 3 assemblies be used in SQL CLR? And if not so, what will happen with the arrival of .Net 5? Or is it only possible to use only .Net Standard 2 and implement it as >net Framework?

Solution

  • Can .Net Core assemblies be used in SQL CLR?

    No. SQL CLR is .NET Framework (even on Linux).

    And if not so, what will happen with the arrival of .Net 5?

    Nothing. .Net 5 is the next version of .NET Core. It gets the big name because .NET Framework will not have another major version after 4.8. This is similar to the big jump from .NET 2 to .NET 4, in that there are breaking changes, side-by-side execution and lots of old applications that never port to the newer version.

    NET. Framework is part of Windows, so it is not going anywhere, and it supports .NET Standard 2.0. So libraries that depend on .NET Standard 2.0 can be used in SQL CLR.