CREATE ASSEMBLY failed because method ‘…’ on type ‘…’ in safe assembly ‘…’ is storing to a static field. Storing to a static field is not allowed in safe assemblies.
When working with CLR inside the SQLserver database one doesn’t have to deploy the DLL through Visual Studio. Instead use the Create Assembly command.
There are several reasons for this command to fail and
CREATE ASSEMBLY failed because method 'AAA' on type 'BBB' in safe assembly 'CCC' is storing to a static field. Storing to a static field is not allowed in safe assemblies.
is one of them.
Unless your assembly is very complex the diagnosis is easy. The AAA is a static something. If it is a property
public static Colour{ get; set; }
AAA will be
set_Colour
CCC is the assembly that refuses to install.
Find AAA. Rewrite to be not static. Compile. Run create assembly again.