If you want to get a random string in SQL then you could use newid to generate a GUID and take the alphanumeric characters from it, however while these should obviously be unique from each other they don’t contain the full range of characters that may be desired and sequential Read more
I use IdentityServer to manage access to a few client APIs with the configuration details stored in SQL. The one downside to using IdentityServer is that there doesn’t yet seem to be a good option for administration of credentials, though Skoruba.IdentityServer4.Admin certainly looks promising. In order to add new clients Read more
There’s a pretty comprehensive set of APIs available for interacting with Azure resources but unfortunately these seem to be so new that there’s not really much documentation around on how to use them. For an example of the information that can be returned by these APIs you can use the Read more
In a similar vein to my post on storing complex properties of a TableEntity in Azure Table Storage it’s also possible to store Enum text values by using custom attributes to control serialization/deserialization.
I’m in the process of building an Azure Function to replicate some of the functionality found in Postcodes.io. This function will accept one or more postcodes as input and return details of the postcodes in the response. This looks retrieves the postcode details from a copy of the ONS Postcode Read more
While trying to add items to a dictionary I discovered that there’s no equivalent of the AddRange which is available for lists. This is for good reason as adding a KeyValuePair to a dictionary requires first checking that the given key doesn’t already exist and so is more computationally expensive Read more
If you want to insert a row into an Azure Table Storage table the easiest way is to create a new class with the desired fields that inherits from TableEntity perform an insert operation with it using the storage client. This works fine as long as long as the properties Read more
In trying to parse some URL parameters in a project I realised that Boolean.Parse and Boolean.TryParse work in slightly different ways and that neither was broad enough for my purposes. Boolean.TryParse Boolean.TryParse takes a string input parameter and a Boolean output parameter and returns a Boolean specifying whether the input Read more
Dependency Injection (DI) has been available in .NET Core Web Applications for a while and now seems to have finally made it’s way to Azure Functions as well and is available in the current Azure Functions Runtime 2.0.12382. The GitHub issue tracking DI implementation in Azure Functions is here. I’ve Read more
If you’re setting up a WordPress site in an Azure Web App then an easy option for hosting the required MySQL database is to use the MySQL in app option of the Web App rather than setting up a new MySQL server. Though it’s worth noting that this isn’t very Read more