A collection of 21 posts
I recently read a blog post from Dustin Moris Gorski titled “The type system is a programmer’s best friend”, and he makes a lot of great points. Typically when dealing with data storage mechanisms, we model our objects using primitive...
You can only catch so many errors when working with databases by looking at the code you write. It’s only when you start using your code against production data sets do you realize there’s an obvious mistake. Sure, your app...
Deleting records from an existing database is a contentious topic. Whether you should or shouldn’t destroy data is up for debate, with strategies like Event Sourcing and Soft-Deletes being prominent proponents of not ever deleting anything. Regardless, Users still see...
While other database providers have made their place known within the .NET ecosystem, Microsoft’s SQL Server (MSSQL) and Azure flavor are still likely the most popular choice for .NET developers. The engine’s popularity is because Microsoft’ s SQL Server has...
Part of software development is researching new tools and finding ways to integrate them with what you know and love. Given today’s technology landscape, having multiple products power your solution in new and exciting ways is not uncommon. While your...
Sometimes you need to break down a large number into smaller chunks. For me, I regularly chunk data when I need to bulk import data records into a database. I find that fine-tuning the chunks can help improve data-loading performance...
Recently, a follower on Twitter asked how they could store “dynamic” user data using Entity Framework Core. Dynamic in the sense that you may not know what the key/value pairs of data will be but they’re still important to store,...
Most relational databases are a modern marvel, with many features waiting for you to use. However, for .NET developers, you often need to discover methods to get data into and out of our database instances that work for our use...
I’ve grown fond of SQLite during my time as a developer advocate. The file-based database with native drivers for every operating system allows me to ship self-contained data-driven sample apps to developers worldwide. Developers can clone a demo and run...
When building APIs that return a non-trivial amount of data, we need to make design decisions based on our underlying database. For example, a developer may implement a specific endpoint in APIs that allows clients to return a window-based collection....
