-- if there is an existing database, remove this AND make sure to change the "USE [db_clr_http_request]" below to direct things to the desired database

CREATE DATABASE [db_clr_http_request];

USE [master]

IF NOT EXISTS (SELECT * FROM [master].sys.asymmetric_keys WHERE [name] = 'key_clr_http_request')

CREATE ASYMMETRIC KEY [key_clr_http_request] FROM EXECUTABLE FILE = 'C:\ClrHttpRequest.dll';

END;

IF NOT EXISTS (SELECT * FROM [master].dbo.syslogins WHERE [name] = 'lgn_clr_http_request')

CREATE LOGIN [lgn_clr_http_request] FROM ASYMMETRIC KEY [key_clr_http_request];

GRANT UNSAFE ASSEMBLY TO [lgn_clr_http_request];

END;

USE [db_clr_http_request]

IF NOT EXISTS (SELECT * FROM dbo.sysusers WHERE [name] = 'usr_clr_http_request')

CREATE USER [usr_clr_http_request] FOR LOGIN [lgn_clr_http_request];

END;

DROP FUNCTION IF EXISTS [dbo].[clr_http_request];

DROP ASSEMBLY IF EXISTS [ClrHttpRequest]

CREATE ASSEMBLY [ClrHttpRequest] FROM 'C:\ClrHttpRequest.dll' WITH PERMISSION_SET=EXTERNAL_ACCESS;

CREATE FUNCTION [dbo].[clr_http_request] (@requestMethod NVARCHAR(MAX), @url NVARCHAR(MAX), @parameters NVARCHAR(MAX), @headers NVARCHAR(MAX), @optionsXml NVARCHAR(MAX))

RETURNS XML AS EXTERNAL NAME [ClrHttpRequest].[UserDefinedFunctions].[clr_http_request];