Erro de segurança ao chamar o serviço da Web externo no visual studio
Estou tentando chamar um serviço da web externo no visual studio, mas estou recebendo o erro.
System.Security.SecurityException: falha na solicitação da permissão do tipo 'System.Security.Permissions.SecurityPermission, mscorlib, Versão = 4.0.0.0, Culture = neutral, PublicKeyToken = b77a5c561934e089'. System.Security.SecurityException: at System.Security.CodeAccessSecurityEngine.Check (Demanda de objeto, StackCrawlMark e stackMark, Boolean isPermSet) em System.Security.CodeAccessPermission.Demand () em System.Net.ServicePointManager.set_ServerCertificateValidationCallback (valor)
A seguir, é o programa para chamar o serviço da web.
public partial class UserDefinedFunctions
{
[Microsoft.SqlServer.Server.SqlFunction(DataAccess = DataAccessKind.Read)]
[return: SqlFacet(MaxSize = -1)]
public static SqlString NYP_RestGet(SqlString uri)
{
String document;
System.Net.ServicePointManager.ServerCertificateValidationCallback +=
delegate(object sender, System.Security.Cryptography.X509Certificates.X509Certificate certificate,
System.Security.Cryptography.X509Certificates.X509Chain chain,
System.Net.Security.SslPolicyErrors sslPolicyErrors)
{
return true; // **** Always accept
};
// Set up the request, including authentication
WebRequest req = WebRequest.Create(Convert.ToString(uri));
((HttpWebRequest)req).UserAgent = "CLR web client on SQL Server";
req.ContentType = "application/xml";
((HttpWebRequest)req).Accept = "application/xml";
WebResponse resp = req.GetResponse();
Stream dataStream = resp.GetResponseStream();
StreamReader rdr = new StreamReader(dataStream);
document = (String)rdr.ReadToEnd();
rdr.Close();
dataStream.Close();
resp.Close();
return (document);
}
};