Consuming ASP.NET Web Services from SQLCLR

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.