Consuming ASP.NET Web Services from SQLCLR

Consuming ASP.NET Web Services from SQLCLR

September 6, 2005 | Microsoft, SQL Server, Visual Studio 2005

I’ve done a lot of things from the SQLCLR thus far, except for consuming an ASP.NET Web Service. This morning, I ran into some difficulties. Here are some key points to remember:

  • Remove any app.config from your SQLCLR project so that VS 2005 can properly deploy
  • Refer to this posting if you get the “Cannot load dynamically generated serialization assembly …” error message
  • Refer to this posting on how to automate the fix above from within Visual Studio 2005

Many thanks to Vineet Rao (Microsoft) for these tips.