The SqlPipe is how we send data back to the caller Public static SqlString GET(SqlString uri, SqlString username, SqlString passwd) Here’s the GET() function in its entirety, with comments: // Function to return a web URL as a string value. The attribute is there for Visual Studio, so it knows that we are building an SQL Server function. You will notice that both functions are prefixed with an attribute (the stuff within brackets). Partial, in this case means that you can split the code over several different files if you want. We’re going to create a class, simply called Functions, but you could call it what you like. We’re setting up two basic functions, GET() and POST(), corresponding to their respective HTTP equivalents. Starting off, we’re including because we’re going to need this to communicate with the server – retrieving arguments and returning values or recordsets. Here’s the example code of a C# procedure that we’re going to use. This may differ between versions of Visual Studio and SQL Server, but you’ll figure it out. In Visual C#, create a new project and select “Class library”, so your code will compile to a DLL file. Any obvious subjects to improvement that you spot, please let me know in the comments section. Let me also start off by say that I’m no C# hero.

The example code will work just fine in the Express Edition of Visual C#. NET 3.0/3.5 framework, and all the code is written in C#.

NET Framework makes a pretty good abstraction for you in its object model.

However, you don’t need any deeper networking knowledge, as the. NET programming and working in Visual Studio. This article assumes that you are familiar with HTTP concepts such as GET and POST. Here, we’ll explore how to write a web request procedure in C#, so you can download a web document (for instance, a file on a REST service) directly into a table or a string variable using just a regular function call. This gives you access to a huge array of APIs, so you can create really cool stuff, way beyond what T-SQL would normally allow you to do. For most things that you can’t do straigh-off in T-SQL, you have the option to write a Common Language Runtime procedure.

Visual studio 2017 sql server clr