How to add a web service reference or connected service in a VS2019 C# SQL CLR?

Question

I am writing a C# SQL CLR project (or "SQL Server Database Project", as it is apparently called now) in Visual Studio 2019 and I need to call a web service from it.

In VS 2017 and earlier it was easy to add a web service reference, but in VS 2019, there is no such option. I tried adding a "Connected Service", but it tells me "No Connected Service is supported for the current project type."

I am looking for a solution or at least a good workaround for this issue...

Thanks.

Lars335 · Accepted Answer · 2020-06-08 22:33:23Z

2

I got this working and I am posting my solution here for others that might need it:

Create a separate Class Library project in the same solution as the CLR project
Add the web service references to the class library
Reference the class library from the CLR to use its web references.

answered Jun 8, 2020 at 22:33

Lars335

1,8803 gold badges23 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add a web service reference or connected service in a VS2019 C# SQL CLR?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related