I've built a SQLCLR function in C# that will deserialize JSON and return a table. The problem I have is getting the correct assemblies within SQL Server 2012. In order to utilize Newtonsoft's deserializer I've had to add the following assemblies to SQL Server: System.ServiceModel.Internals.dll SMDiagnostics.dll System.Runtime.Serialization.dll Newtonsoft.Json.dll This has [...] read more
I have added a third party dll (Extreme.Numerics.Net20.dll to my sql server assemblies). I then opened by VS 2008 project and added that assembly as a reference. Then I built and released my project and it created a PowerstatRegression.dll. Then I add that assembly to SQL Server as well. But [...] read more
I have created a SQL CLR Stored Procedure which will call a WCF Service. I have managed to get all the correct DLL's loaded into SQL Server to get this to work however I now have following error message: System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for system.serviceModel/extensions: [...] read more
I want to take a look at the Data Quality Services feature in the Denali CTP; I happen to have a clean Windows 7 virtual PC image, and have installed the CTP. Running up the DQS client gave the error: > The SQL Server instance that you are trying to [...] read more
I have a requirement set upon me to run a .NET Standard project from T-SQL. I'm finding very little info about this. I've set the TRUSTWORTHY setting to ON. Importing the test program dll I'm receiving the error below. Importing test.dll error [https://i.stack.imgur.com/FUqqh.png] I try importing the netstandard.dll from the [...] read more
I created a custom assembly using C# that has the following dependencies: 1. Newtonsoft.Json.dll 2. SMDiagnostics.dll 3. System.ServiceModel.Internals.dll 4. System.Runtime.Serialization.dll This assembly then is being loaded into SQL Server 2012 to be executed by a SQL function. When I Create the assembly on SQL Server 2012 Express running .NET v4.0 [...] read more
I have an assembly which I am trying to run from SQL, but failing due to the following error, which I hope is something trivial. Could not load file or assembly 'System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. Assembly in host store has a different signature than assembly [...] read more