Irony as SQL Server Assembly

Feb 4, 2011 at 12:32 PM

Dear all,

I need to create an SQL Server assembly from Irony dll.

Can someone please provide a guide in order to achieve this? Any help would be grateful.

Regards,

Jonimatix

Coordinator
Feb 5, 2011 at 6:52 PM

We tried it in the past, you may find a discussion about this some long time ago. The problem is that SQL Server requires all classes in assembly it loads must be "safe"; among other things it means classes or anything they use from .NET framework must not be marked with HostProtectionAttribute; I tried to factor out such classes but gave up - many of quite useful and quite "innocent" classes like Hashset are marked with this attribute, so it did not seem reasonable to continue. One stupid thing about this is that SQL server reports the first offending class, not all of them; so after you remove it, you get next, and it is unknown when the process will end. I gave up on Hashset. 

Sorry for bad news

Roman