I sometimes (not as much as I would like) hang out at some of the user forums where people talk about SQL Server generally and the SQLCLR specifically. Ever so often the question is being asked how to call into a WCF service from SQLCLR (.NET code running inside SQL Server).
The other day I became tired of giving exactly (or thereabout) the same answer for the n:th time, so I decided to croft up some code and write a mini How-To about how to call into a WCF service from SQLCLR. So without any further ado, the How-To article can be found here. I do not have anywhere to host the code yet (my usual hosting place disappeared – don’t ask), so until I decide where to host you can drop me an email if you want to see the code.
Update: I have now created a Resource Page on MSDN’s code gallery, where the sample code for the article can be found. So if you want to get the code, go to here.
February 12, 2009 at 8:49 am |
[...] managed data Niels Berglund’s musings about technology and life in general « How-To Article about Calling a WCF Service from SQLCLR [...]
August 14, 2009 at 7:47 am |
[...] other day when I posted about the sample how to call a WCF Service from a SQLCLR method, I mentioned that I had no place to [...]
August 25, 2009 at 8:04 am |
Please check this link.
http://blogs.msdn.com/saradhic/archive/2007/09/12/invoke-wcf-service-via-sql.aspx