I use Serilog to log to a SQL database in most of my web applications and although it’s pretty well documented the details relevant to my projects are spread out over a few sites so I figured I’d gather them here together for future reference. Packages Install these packages from Read more…
Importing CSV files into a .NET object isn’t too tricky and for this I usually use CsvHelper. However, sometimes I need to import a CSV file and only extract a couple of columns from it and these columns aren’t always guaranteed to exist. In order to do this I use Read more…
If you want to check if one instance of a custom class is equal to another instance of it you need to override the Equals operator for the class and implement your own. The code below is based on the articles The Right Way to do Equality in C# and Read more…
Sometimes in an MVC controller you just want to return a HTTP status code from a method rather than a view or data object. This is pretty simple but is done slightly differently in .NET Core than it was done previously. Some of the more common status codes such as Read more…
I’ve had a raspberry Pi for a while now and one of the projects I’ve wanted to do but never actually got around to was to use it as a weather station as in this example from Microsoft. Unfortunately getting this working wasn’t as easy as expected, though this was Read more…
I’ve been working to create a virtual file system for SQL databases and represent this in a web interface. While creating the classes in .NET I realised that I needed to be able to traverse all the ancestors of a file up to the root level and to flatten these Read more…
I’ve previously used “Individual User Accounts” authentication for authenticating users in web applications but as the management of users in the underlying SQL databases isn’t that simple it seemed that using Azure Active Directory to manage users might be a better option. The first step in the process is to Read more…
I recently built a new PC based on the Gigabyte Z370 AORUS Gaming 7, as this is a pretty new motherboard I figured I’d try and update the BIOS/UEFI to the latest version. Unfortunately it seems the Q-Flash utility for doing this doesn’t work properly (at least not for me). Read more…
I’ve just built a new computer and have been setting up all my software on it again, as part of that I need to set up Calibre to download news and send it to my Kindle via my Gmail account. The first thing to take care of is whitelisting the Read more…
I’ve gotten so used to working with JSON that I’d almost forgotten what a chore it can be to work with XML. A case in point is the below XML sample that I’m trying to deserialize into a class, essentially I want to capture all the attributes of the “Attribute” Read more…