I created a SQL CLR stored procedure that will call the WCF service. I managed to get all the necessary DLL loaded into SQL Server to get this to work, but now I have the following error message:
System.Configuration.ConfigurationErrorsException: An error occurred while creating a configuration section handler for system.serviceModel / extensions: Failed to load file or assembly 'System.IdentityModel, Version = 3.0.0.0, Culture = neutral, PublicKeyToken = b77a5c561934e089' or one of its dependencies . The assembly in the host store has a different signature than the assembly in the GAC. (Exception from HRESULT: 0x80131050) (C: \ Windows \ Microsoft.NET \ Framework64 \ v2.0.50727 \ Config \ machine.config line 185) System.Configuration.ConfigurationErrorsException: in System.Configuration.BaseConfigurationRecord.EvaluateOne (String [] , entry into the Input section, boolean isTrusted, FactoryRecord factoryRecord, Record sectionRecord, Object parentResult) in System.Configuration.BaseConfigurationRecord.Evaluate (FactoryRecord factoryRecord,SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object & result, Object & resultRuntimeObject) in System.Configuration.BaseConfigurationRecord.GetSectionRecursive (String configKey, Boolean getLkg, Boolean checkPermentObjectle & BooleleOrme, BooleanOrme, Boolean, RequestBermoohoo resultRuntimeObject) in System.Configuration.BaseConfigurationRecord.GetSectionRecursive (String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object & result, Object & resultRuntimeObject) in System.Centrefonckrefiguration checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object & result, Object & resultRuntimeObject) in the System.Configuration.BaseConfigurationRecord.GetSectionRecursive (String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object & result, Object & resultRuntimeObject) in System.Configuration.BaseConfigurationRecord.GetS ...
, , GAC : ( WCF CLR)