you will have to:
create a signed assembly in .net environment
create an asymentic key on sql server for the .net assembly
grant EXTERNAL_ACCESS or UNSAFE permission set to the .net assembly
probably create a login for the asymetric key
and you might additionally need to assign permissions to the user that is running the sql server process
Everything you can imagine is real.