bitScry

  • Home
  • Blog
  • Contact
  • GitHub

Table Storage

About This Site

This is a blog to help me remember some of the coding challenges I’ve faced and hopefully help others out if they’re suffering the same problems.

Recent Posts
  • Inspecting Data in SQL Tables 4th December 2020
  • RestSharp Response Character Encoding 24th September 2020
  • RestSharp AWS S3 Authentication 18th September 2020
  • Grouping Azure Table Storage Entities 17th September 2020
  • Best Practices for Using Azure SDK with ASP.NET Core 9th September 2020
Tag Cloud
.NET .NET Core API appsettings.json ASP.NET Core Authentication Authorization Azure Azure Active Directory Azure AD Azure Function Azure Storage Blob Bootstrap C# Console Application CSS CSV DataTable Dependency Injection Dictionary Enum Extension GZip HTML Image JavaScript jQuery JSON List Middleware MVC MVC 6 Random Serilog SFTP SQL Stored Procedure Stream String Table Table Storage Tag Helper Web Application WordPress
Reading List
  • Build a Wi-Fi Scanner
  • IoT Weather Station
  • User accounts made easy with Azure
  • Install macOS High Sierra in VirtualBox
Programming

Grouping Azure Table Storage Entities

If you’re using Azure Table Storage then it’s often more efficent to perform operations such as insert, update, delete in batches rather than making seperate calls for each individual row. There can be up to 100 entities in each batch and each all entities in a batch need to have Read more…

By Shinigami, 4 months4 months ago
Programming

Reading SQL JSON Results into .NET Core

If you have a complex table structure in SQL that you want to map into corresponding classes in your .NET Core project it might be easier to output the result of your SQL query as JSON and then deserialize the results to your object model rather than trying to map Read more…

By Shinigami, 7 months7 months ago
Programming

Converting a Char Character to an Enum in Entity Framework

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 a separate status table which would allow the IDs to Read more…

By Shinigami, 1 year1 year ago
Programming

Adding TableEntity Enum Text Values to Azure Table Storage

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. ReceiptRequestEntity.cs EntityEnumPropertyConverterAttribute.cs

By Shinigami, 2 years2 years ago
Programming

Adding Complex Properties of a TableEntity to Azure Table Storage

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…

By Shinigami, 2 years2 years ago
Programming

Efficiently Deleting Rows from Azure Table Storage

Azure Table storage is a way of storing structured NoSQL data in the cloud, as such it’s more geared towards rapid read access rather than manipulation of data in the table. If you want to perform any operations such as updates or deletes on data in your table then the Read more…

By Shinigami, 2 years2 years ago
Hestia | Developed by ThemeIsle