Base Class Library in Sql Server Clr Project

Question

I'm trying to reference a class library from the Visual C # SQL CLR Database Project , but getting an error

A reference to the "class library" cannot be added. SQL Server projects can only reference other SQL Server projects.

Is there a way to add a link, so I don’t need to duplicate the code in this class library?

EDIT is the solution?

My current solution is simply adding some required class files to the SQL Database CLR project as links to real files. Thus, the code is in one place, although it will be built in two different places. It seems to work for my purposes.

Answer 1

, . sql CREATE ASSEMBLY, :

CREATE ASSEMBLY ClassLibrary5
FROM 'c:\projects\classlibrary5\bin\release\classlibrary5.dll' 

, " " , SQL Server.