Using SQL Task Results in a Script Task in SSDT In SSDT if you want to access the results of a SQL query in a script task you can do this by outputting the results as a full result set Read more…
Getting a List of Countries and Their Identifiers The RegionInfo class in System.Globilization provides useful details about a region (country) such as the name, currency and ISO identifying codes. If you want to get a RegionInfo for every available country Read more…
Using Let’s Encrypt SSL Certificates with Azure Functions In Azure Web Apps I’ve set up previously I’ve managed to get SSL certificates for the custom domains used by using the “Let’s Encrypt” site extension in the kudu management portal as Read more…
PGP Encryption and Decryption in C# A while ago I knocked up a NuGet package called PgpCore which uses the BouncyCastle library to easily encrypt and decrypt files and streams. The code for the project is here and this post Read more…
ASP.NET Core Rewrite Middleware Extensions I’ve recently updated my site and one of the demo projects on it uses the Bing Image Search API to fetch a list of images and display them. This worked fine when running locally but Read more…
Bing Image Search API The Image Search API lets you query the Bing search engine for a list of relevant images, in order to access it you need a cognitive services API key obtained from the Azure portal. The API Read more…
Upper Case the First Letter of a String This is a simple string extension for upper casing the first letter of a string, the code originally came from here. public static class StringExtensions { public static string FirstLetterToUpperCase(this string s) Read more…
ASP.NET Core API Routing When creating a new API controller in a Web Application the template code created if you choose to include read/write actions provides a good overview of how to pass values through to the API methods and Read more…
User GeoLocation in ASP.NET Core If you want to get the physical location of a user on your site there’s a couple of different methods that you can use, you can either use their IP address to get an approximate Read more…
Bootstrap 4 Contact Form with Google reCaptcha I’ve just started building a site using Bootstrap 4 which is different enough to Bootstrap 3 that I’m having to relearn a few things. One of those is form validation as previously I Read more…