title: Can consume a service from SOAP UI however SQL Clr to call the service does not work
body: <p>I have a simple SOAP service which takes one parameter(long) and returns a string.  I have used SOAP UI and I am able to access the service fine and get a successful response.  </p>
  
  <h2>What is that iam trying to achieve</h2>
  
  <p>SQL store procedure which will fetch the ID from the database (parameter for the service). 
  Make a call to C# assembly (SQL CLR)
  C# assembly returns the result string back to SQL.  </p>
  
  <h2>I have tried the following</h2>
  
  <h2>Aproach 1</h2>
  
  <p>Create a c# class library with service reference to my service.  The method is exposed correctly 
  e.g., GetConfigPath(long id)
  However when I try to install the library into SQL I get a error.  The assembly looks for System.ServiceModel and it is not found in SQL blah.  </p>
  
  <h2>Approach 2</h2>
  
  <p>I used the following link and followed step by step (obviously changed the parameters to suit my requirement etc)</p>
  
  <p>[<a href="https://code.msdn.microsoft.com/Calling-WCF-Service-from-a-8071ceaa#content][1]" rel="nofollow noreferrer">https://code.msdn.microsoft.com/Calling-WCF-Service-from-a-8071ceaa#content][1]</a></p>
  
  <p>When i was adding webreference as shown in the link above, I noticed that my method had an additional parameter
  e.g., GetConfigPath(long id, bool idpassedin)</p>
  
  <p>I thought it might be default so I continued and installed the stored procedure into the database exactly as show in the link above.  The installation script works fine.  However when I run the stored procedure I get the following error. </p>
  
  <p>The request failed with HTTP status 400: Bad Request.</p>
  
  <p>I am using the following tools
  VS2015
  SQL 2014</p>