HOWTO add a C#.NET library to SQL Server as an assembly that uses such references as system.web.
I have a C# library (dll) I want to add to SQL Server via "CREATE ASSEMBLY", but the DLL uses these references:
And just to be clear, the DLL is a .NET 3.5 app, with the SQL Server being SQL Server 2008.
Right off the bat, the "CREATE ASSEMBLY" call fails due to System.Web, which strangely, is 22.214.171.124. The CREATE ASSEMBLE says this error:
Msg 10301, Level 16, State 1, Line 1
Assembly 'MyLibrary' references assembly 'system.web, version=126.96.36.199, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same
location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request.
I have tried to use VS 2010, to create a SQL Server DB project, and it point blank does not let one add references to things like System.Web. When trying to use "Add Ref", VS 2010 literally lo
View Complete Post