Calling WCF from SQL Server Serialization issue. RRS feed

  • Question

  • User-1796506859 posted

    Hi Folks,

    I have an existing WCF service that is using serialization (attribute on the class).  I can't change this service as it is used by a few applications.

    I have a SQL Server [2012] CLR table valued function that I can call within SQL server successfully.   I need to modify this function so that it makes a call to the WCF Service. 

    However, when using SVCUtil to generate the proxy it is adding serialization code to the proxy (I am not using the /s command when calling SVCUtil).  The generated datacontract is being tagged with a  [System.SerializableAttribute()] and is inheriting from System.Runtime.Serialization.IExtensibleDataObject.

    The issue is that I am getting an error  SQL72014 .Net SqlClient Data Provider: Msg 6503..... Assembly 'system.runtime.serialization..... not found in sql catalog. 

    Does anyone have any idea on how I can turn off the addition of the serialization code as I don't believe it is allowable in SQL CLR.




    Monday, March 18, 2013 9:20 PM