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.