I’ve previously posted about how to cope with nullable values retrieved from a SqlDataReader but it’s also necessary to account for nulls when passing values through to a SQL operation such as a stored procedure. sp__set_completed.sql If you want you’re Read more…
I maintain a library called PGPCore for using PGP encryption in C#, in order to test how this performs when processing large files I needed to create a large file full of random data to check it was encrypting/decrypting as Read more…
I use Bootstrap 4 as the framework for most sites that I build and I’m mostly happy with how it works, though one area where I think it could be a bit more user friendly is in Form Validation. This Read more…
I recently needed to mask out some characters of a credit card string so that only the last 4 were displayed. Surprisingly there doesn’t seem to be many good examples of this so I decided to put together something myself Read more…
I have a table in Azure Table Storage that I need to keep as a replica of a local SQL table. Adding/updating rows from the local table is simple enough but it is slightly more complicated to find rows that Read more…
CsvHelper is handy for reading and writing CSV files but there’s no obvious way to write out a DataTable to a CSV file. Therefore in order to do this we need to loop through all the rows and columns of Read more…
Previously when I’ve wanted to read a blob from Azure Storage I’ve opened it as a CloudBlockBlob which allows you to read it using just OpenReadAsync(). If you want to use an ICloudBlob then you need to provide AccessCondition, BlobRequestOptions Read more…
If you’re using Entity Framework with a legacy database then you may well have single character status flags in some of the columns such as “O” = Operational, “M” = Marketing. Ideally these would be numeric IDs that match to Read more…
If you’re using VARCHAR(MAX) columns in SQL then you may occasionally want to view the stored values in SQL Server Management Studio (SSMS) as part of the debugging process. Because a VARCHAR(MAX) field can store up to 2GB of data Read more…
I’ve been working on a web portal that users Azure Active Directory (AAD) for user authentication and for requesting permissions to the Azure Graph API, the code for which is based on this sample project. This uses a library called Read more…