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 into a variable of type Object and then load this Read more
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 then you can use the following code which Read more
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 detailed here. I’d hoped it would be as Read more
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 is mainly here to point anyone 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
This is a simple string extension for upper casing the first letter of a string, the code originally came from here.
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
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 return results. The template Read more
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 location or you can request Read more
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 used bootstrap-validator though this doesn’t yet work Read more