newtonsoft.json parser - how to deploy a CLR to SQL Server 2008 R2?
-
I have created a CLR which uses the newtonsoft json parser. I need to deploy the CLR. I have created an assembly for the parser dependency: CREATE ASSEMBLY [Newtonsoft.Json] FROM 'C:\share\Release\Newtonsoft.Json.dll' WITH PERMISSION_SET = UNSAFE The above statement throws an error: Assembly 'Newtonsoft.Json' references assembly 'system.runtime.serialization, version=3.0.0.0, culture=neutral, publickeytoken=b77a5c561934e089.', 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(failed to retrieve text for this error. Reason: 15105)). Please load the referenced assembly into the current database and retry your request. I am using version 7.xx of the parser. I am targeting .NET 3.5 What is the proper procedure for deploying the CLR to sql server 2008 r2?