I've created a .Net C# function (target Framework is .Net 4.5) which works perfectly with a stored function created with the 'CREATE FUNCTION ...language clr' syntax.

However, if I add extra functionality to the C# function (it references a second DLL, 'DocumentFormat.OpenXml'), the second DLL can't be loaded.

The SQL error reads '...assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded'.

I've used the 'Assembly Binding Log Viewer' tool from Microsoft to analyse the binding process, which reads: (the log is in Dutch, and I only printed the first 5 lines)

*** Logboekvermelding voor assembly-binder  (08-09-2014 @ 14:39:35) ***

De bewerking is mislukt.
Resultaat van binding: hr = 0x8013101b. Geen beschrijving beschikbaar.

Assembly-beheer geladen vanuit:  C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll
Wordt uitgevoerd onder uitvoerbaar bestand  C:\Windows\system32\odbc\16\dbextclr16.exe

I think the dbextclr16.exe is executed using the .Net 2.0 Framework. Am I missing some essential code or isn't this supported (yet) in SQL Anywhere?

I'm using SQL Anyhwere 16.0.0 build 1989