sql server - I cannot use WCF in SQL CLR 2012 -

sql server - I cannot use WCF in SQL CLR 2012 -

when adding assemblies sql server 2012, dependencies draw in system.servicemodel wich draws in microsoft.visualbasic.activities.compiler, , bring next error:

create assembly assembly '<assembly name>' failed because assembly 'microsoft.visualbasic.activities.compiler' malformed or not pure .net assembly. unverifiable pe header/native stub.

it seems wcf dlls cannot added sql server 2012.

is there workaround? fixed in sql server 2014?

no, sql-server allows rather limited subset of c#, security reasons. example, adding reference system.web sufficient doesn't work.

perhaps can rip part of system.servicemodel need out of mono sourcecode , work way. luck, if need 1 or 2 function calls, can work few changes.

on sidenote: if add together wcf in clr-stored procedure, create sql-express utilize http-endpoints. 1 of defining limitations of sql-server express is, express version doesn't allow that. if possible, circumvent limitation, , microsoft doesn't want that.

see post: wcf client within sql clr

sql sql-server wcf clr sqlclr