SQL Server通过程序集调用WebAPI

类库

using Microsoft.SqlServer.Server;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Net.Security;
using System.Text;
using System.Threading.Tasks;

public class WebAPIHelper
{
    [SqlFunction]
    public static string Call(string token, string method, string url, string pms)
    {
        if (method.ToUpper() == "GET")
        {
            return Get(url, token);
        }
        else
        {
            return Post(url, pms, token);
        }

    }

    private static string Post(string URL, string model, string token = "")
    {
        HttpWebRequest request = null;
        if (URL.ToLowerInvariant().StartsWith("https"))
        {
            request = WebRequest.Create(URL) as HttpWebRequest;
            ServicePointManager.ServerC