SQL server 2008 CLR version #4
Description
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.