public class RemoteWeather
{
    private static System.Data.SqlDbType GetSqlDbTypeFromClrType(System.Type clrType, out int size, out int precision)
    {
        size = 0;
        precision = 0;
        if (clrType == typeof(System.Boolean))
            return System.Data.SqlDbType.Bit;
        if (clrType == typeof(System.Byte))
            return System.Data.SqlDbType.TinyInt;
        if (clrType == typeof(System.Int16))
            return System.Data.SqlDbType.SmallInt;
        if (clrType == typeof(System.Int32))
            return System.Data.SqlDbType.Int;
        if (clrType == typeof(System.Int64))
            return System.Data.SqlDbType.BigInt;
        if (clrType == typeof(System.SByte))
            return System.Data.SqlDbType.SmallInt;
        if (clrType == typeof(System.UInt16))
            return System.Data.SqlDbType.Int;
        if (clrType == typeof(System.UInt32))
            return System.Data.SqlDbType.BigInt;
        if (clrType == typeof(System.UInt64))
        {
            size = 20;
            return System.Data.SqlDbType.Decimal;
        }
        if (clrType == typeof(System.Decimal))
        {
            size = 29;
            precision = 4;
            return System.Data.SqlDbType.Decimal;
        }
        if (clrType == typeof(System.Single))
            return System.Data.SqlDbType.Real;
        if (clrType == typeof(System.Double))
            return System.Data.SqlDbType.Float;
        if (clrType == typeof(System.String))
            return System.Data.SqlDbType.NVarChar;
        return System.Data.SqlDbType.Variant;
    }
 
 
    [Microsoft.SqlServer.Server.SqlProcedure]
    public static void GetWeatherByZIP(SqlString zip)
    {
        try
        {
            Microsoft.SqlServer.Server.SqlContext.Pipe.Send("Connecting ...\r\n");
            System.ServiceModel.BasicHttpBinding binding = new System.ServiceModel.BasicHttpBinding();
            Weather.ServiceReference.WeatherSoapClient client = new Weather.ServiceReference.WeatherSoapClient(
                binding, new System.ServiceModel.EndpointAddress("http://wsf.cdyne.com/WeatherWS/Weather.asmx"));
            Microsoft.SqlServer.Server.SqlContext.Pipe.Send("Connected.\r\nTry to call GetCityWeatherByZIP ...\r\n");
            if (client != null)
            {
                Weather.ServiceReference.WeatherReturn result = null;
                object obj = client.GetCityWeatherByZIP(zip.Value);
                Microsoft.SqlServer.Server.SqlContext.Pipe.Send("Called sucessful.\r\nTry to get type of result ...\r\n");
                Type weatherType = result.GetType();
                List<Microsoft.SqlServer.Server.SqlMetaData> mds = weatherType.GetProperties().Select((System.Reflection.PropertyInfo pi) =>
                {
                    Microsoft.SqlServer.Server.SqlMetaData mdResult = null;
                    int size = 0;
                    int precision = 0;
                    System.Data.SqlDbType convert = GetSqlDbTypeFromClrType(pi.PropertyType, out size, out precision);
 
                    if (size == 0 && precision == 0 && pi.PropertyType != typeof(System.String))
                        new Microsoft.SqlServer.Server.SqlMetaData(pi.Name, convert);
                    else
                        if (pi.PropertyType == typeof(System.String))
                            new Microsoft.SqlServer.Server.SqlMetaData(pi.Name, convert, 4000, precision, SqlCompareOptions.None);
                        else
                            new Microsoft.SqlServer.Server.SqlMetaData(pi.Name, convert, size, precision, SqlCompareOptions.None);
 
 
                    return mdResult;
                }).ToList();
                Microsoft.SqlServer.Server.SqlContext.Pipe.Send("Connected !!!\r\nTry to get result ...\r\n");
                Microsoft.SqlServer.Server.SqlDataRecord ret = new Microsoft.SqlServer.Server.SqlDataRecord(mds.ToArray());
                Microsoft.SqlServer.Server.SqlContext.Pipe.SendResultsStart(ret);
                ret.SetValues(weatherType.GetProperties().Select(i => i.GetValue(result, null)).ToArray());
                Microsoft.SqlServer.Server.SqlContext.Pipe.SendResultsRow(ret);
                Microsoft.SqlServer.Server.SqlContext.Pipe.SendResultsEnd();
                Microsoft.SqlServer.Server.SqlContext.Pipe.Send("Connected - HUR-A-A-A-A-A !!!\r\n");
            }
            else
                Microsoft.SqlServer.Server.SqlContext.Pipe.Send("OH !!! - Object is NULL !!!\r\n");
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }
}

ALTER DATABASE MyDB SET TRUSTWORTHY ON

Connecting ...
Msg 6522, Level 16, State 1, Procedure GetWeatherByZIP, Line 0
A .NET Framework error occurred during execution of user-defined routine or aggregate "GetWeatherByZIP":
System.Security.HostProtectionException: Attempted to perform an operation that was forbidden by the CLR host.
 
The protected resources (only available with full trust) were: All
The demanded resources were: Synchronization, ExternalThreading
 
System.Security.HostProtectionException:
   в RemoteWeather.GetWeatherByZIP(SqlString zip)