I am attempting to use a CLR stored procedure to update a database from a WCF webservice. My database is SqlServer 2008 R2. I found this article which is helpful - but dated:
http://blogs.msdn.com/b/sqlclr/archive/2005/07/25/vineet.aspx It references SqlServer 2005 beta 2 and precedes WCF - so in the end it doesn't get me where I need to go. I have
a few questions:
- Does anyone know of an updated reference on how to connect to a web service using a CLR web service?
- I'm using Visual Studio 2010 - but the use of CLR stored procedures does not seem to have caught up - since I think it requires the use of .NET Framework 3.5. Does anyone know otherwise?
- I'm open to suggestions on whether a CLR stored procedure is even the right thing to do. Here is the architecture: A request for data comes from an SSRS report consumer. Some infrequently called reports require data with no latency - while most allow
long latency. SSRS makes it easy to cache & manage this part of the problem. Each report calls a stored procedure. Reports with a zero latency requirement call an "update" stored procedure (which imports the most recent data from an external source which
is only available via https) prior to generating a call against the much larger data warehouse. I
View Complete Post