Article on SQL .NET CLR - Application Configuration Settings Posted to SqlJunkies.com
An article I wrote a couple weeks back has been posted to www.Sqljunkies.com
Accessing Application Configuration Settings from SQL CLR
Recently, one of my peers asked a question regarding the ability of SQL CLR classes to read configuration data from an Application Configuration file. After doing some quick Google searches on the topic, I came up with a couple of links that indicated the potential, but no concrete HOWTO on getting it all wired up.
Now, I don’t want to debate whether this makes good architectural sense to store static settings in the file system when you’re already working inside a database management system that could just as easily save these settings to a table. A scenario that you might leverage this capability is to re-use an existing Application Configuration file, specifically, the <appSettings> element from an already built and working assembly from another application.
This article also uncoves a bug in the SQL CLR implementation that if you don’t know about it you will have issues reading the settings.
Continue at source…