Arachnode deployment to Azure (v12) fails with the below text. So there is some functionality not supported in Azure. I wonder if this is a big part of Arachnode or something that could be dealt with?
Error SQL72014: .Net SqlClient Data Provider: Msg 40517, Level 16, State 1, Line 4 Keyword or statement option 'unsafe' is not supported in this version of SQL Server.
Error SQL72045: Script execution error. The executed script:
CREATE ASSEMBLY [Arachnode.Functions]
Pardon the delay - I'll be back tomorrow to answer this.
For best service when you require assistance:
The error pertains to Azure not supporting the UNSAFE assembly designation for the Function project.
Specifically, for this: [SqlFunction(DataAccess = DataAccessKind.Read)]
UNSAFE is required for: http://www.sqlservercentral.com/articles/Stairway+Series/112888/
If you don't anticipate needing to fall back to using the non-DB helpers then you can relax these to none, and comment out the XDocument.Load(...); calls.
Every time I have looked at Azure integration I have never been able to make a case for a full-fledged effort. Why? $$$!!!
I have very little experience with Azure - however, knowing that AN can utilize all of a computer's resources, at $896 a month (the CHEAP option) you could purchase dedicated hardware (say, two months of Azure $$$ and get DDR4 & an i7-6770K) and spend the $$$ on a nice Fiber/100Mb connection.
There really are so many better options than Azure for the amount of compute cycles/disk space AN can/will consume.