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…
Entity Framework is a nice way of accessing databases without having to write any data access code. Because Entity Framework is able to modify data in your database it needs a primary key to be defined in order for it Read more…
It’s easy enough to send messages to an Event Hub using the EventHubs NuGet package as specified here, but if you want to test it by making you’re own HTTP POST requests to the endpoint then it becomes a bit Read more…
I bought the Logitech G Pro Wireless mouse last week as my old mouse was getting a bit skanky and I wanted something nice to replace it with. So far I like it but the one annoyance was that when Read more…
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 Read more…