I am consuming web service in CLR stored procedure. For this i used VS 2005 web reference method to get the proxy object. It works fine.
I want to place web service url (ex: http://mywebserver/myservice?wsdl) ) in an external file like app.config etc. And fetch the url while execution of clr stored procedure.Here I want to isolated the web url from clr code.
Is there any possibility to refer the web service url from config file which is outside of clr dll?
Please let me know if any one have any idea how it can be done.
Thanks in advance.
View Complete Post