Geeks With Blogs

News





INauseous() Shawn Cicoria - Solution Architect, Craftsman and Artisan - INauseous() - Main Blog Here: www.Cicoria.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…

Posted on Monday, May 15, 2006 5:22 AM | Back to top


Comments on this post: Article on SQL .NET CLR - Application Configuration Settings Posted to SqlJunkies.com

Comments are closed.
Comments have been closed on this topic.
Copyright © Shawn Cicoria | Powered by: GeeksWithBlogs.net