Unable to create Assembly in SQL server 2008. it throws the error.
CREATE ASSEMBLY for assembly 'SqlServerSlackAPI' failed because assembly 'SqlServerSlackAPI' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
So I changed the target framework version in visual studio and builds but it throws some error.
------ Build started: Project: SqlServerSlackAPI, Configuration: Debug Any CPU ------
C:\Program Files (x86)\MSBuild\12.0\bin\Csc.exe /noconfig /nowarn:1701,1702,2008 /nostdlib+ /warn:4 /define:DEBUG;TRACE /errorendlocation /preferreduilang:en-US /highentropyva- /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Xml.dll /debug+ /debug:full /keycontainer:VS_KEY_9EEE88A9BEA24A1E /optimize- /out:obj\Debug\SqlServerSlackAPI.dll /target:library /utf8output Properties\AssemblyInfo.cs Include_T4Include.cs UserDefinedFunctions.cs SlackChatApi.cs SlackChatMessageResult.cs "C:\Users\bhuvanesh\AppData\Local\Temp\3.NETFramework,Version=v3.5.SqlClrAttributes.cs"
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(83,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(89,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(95,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
Done building project "SqlServerSlackAPI.sqlproj" -- FAILED.
Unable to create Assembly in SQL server 2008. it throws the error.
CREATE ASSEMBLY for assembly 'SqlServerSlackAPI' failed because assembly 'SqlServerSlackAPI' failed verification. Check if the referenced assemblies are up-to-date and trusted (for external_access or unsafe) to execute in the database. CLR Verifier error messages if any will follow this message
So I changed the target framework version in visual studio and builds but it throws some error.
------ Build started: Project: SqlServerSlackAPI, Configuration: Debug Any CPU ------
C:\Program Files (x86)\MSBuild\12.0\bin\Csc.exe /noconfig /nowarn:1701,1702,2008 /nostdlib+ /warn:4 /define:DEBUG;TRACE /errorendlocation /preferreduilang:en-US /highentropyva- /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorlib.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Xml.dll /debug+ /debug:full /keycontainer:VS_KEY_9EEE88A9BEA24A1E /optimize- /out:obj\Debug\SqlServerSlackAPI.dll /target:library /utf8output Properties\AssemblyInfo.cs Include_T4Include.cs UserDefinedFunctions.cs SlackChatApi.cs SlackChatMessageResult.cs "C:\Users\bhuvanesh\AppData\Local\Temp\3.NETFramework,Version=v3.5.SqlClrAttributes.cs"
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(83,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(89,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
D:\SqlServerSlackAPI-master\src\SqlServerSlackAPI\SlackChatApi.cs(95,24): Error: CS0117: 'string' does not contain a definition for 'IsNullOrWhiteSpace'
Done building project "SqlServerSlackAPI.sqlproj" -- FAILED.