Data
news

MongoDB BSON Mapping in C#: Explicit Names, Records and ID Types

A guide to how the MongoDB C# driver maps objects to BSON documents. It covers explicit element names, creator maps for immutable records, choosing the BSON _id type, and ignoring extra fields. It also argues that compatibility should be checked against stored fixtures, not only a fresh round trip.

Dapper FluentMap Is Back: What Changed from 2.0 to 3.6

After six years without a stable release, Dapper FluentMap is maintained again and version 3.6.0 adds nested mappings, property converters, isolated runtimes, analyzers and source generators. The author stresses keeping existing applications working during upgrades. The piece also covers what to check before moving from 2.0.0 and which databases are certified.

PostgreSQL Connection Pooling: Preventing Connection Exhaustion in Production

A practical guide to configuring Npgsql connection pooling in .NET and sizing pools across multiple application instances so PostgreSQL does not run out of connections. It stresses that pool limits must be calculated for the whole deployment, not a single process.

SQL Server Always Encrypted: How Secure Enclaves Change Query Support

Always Encrypted encrypts SQL Server columns on the client, so the database engine never sees their plaintext. Secure enclaves can run some otherwise blocked query operations inside a protected environment. The article walks through choosing an encryption type, defining the column and configuring a .NET client.

Multi-tenancy in EF Core: no tenant means no rows

The author shows a multi-tenancy pattern for ASP.NET Core and EF Core that uses global query filters so each request only sees its own tenant's rows. When no tenant is set, filtered queries return nothing, which fails closed. The post also covers tenant-scoped unique indexes, limiting IgnoreQueryFilters(), and an integration test that checks cross-tenant access. It is a practical starting point for SaaS backends.

Resilient Retries and Read Replicas in OrmLite

ServiceStack v10.4 lets OrmLite retry temporary database errors such as deadlocks, throttling and failovers through a single configuration line. It also adds read replica support, with read-only connections that reject writes even on the primary so replica bugs surface during development. Both features matter for any .NET app that talks to a database under load.

EF Core Migrations: Why Bundles Beat Startup MigrateAsync()

This guide explains why running MigrateAsync() at application startup couples deployments to schema changes and grants the app more database permissions than it needs. It walks through EF migration bundles as a controlled CI deployment step, with GitHub Actions and local examples. It also covers when runtime migrations are acceptable and the practical limits of bundles, such as the lack of a dry run.

Designing out double charges and overselling in an ASP.NET Core POS

A write-up on Tilly POS, a multi-branch point-of-sale built with ASP.NET Core 10, EF Core and SQL Server, explains how three costly failures were designed out: double charges, half-written sales and overselling. The fixes are practical: idempotency keys backed by a unique index, one transaction per sale, and a single conditional UPDATE for stock. Useful for any .NET service that moves money or inventory.

Inspecting Local Data with Azure Cosmos DB Shell

Azure Cosmos DB Shell lets you browse databases, containers and items from the terminal. This walkthrough pairs the shell with the local Azure Cosmos DB Linux Emulator and the FleetCharge sample data to show connecting, navigating, querying and point reads. It is a practical way to check what your application actually stored during development, without opening the portal or adding diagnostic code.

EF Core 11: Indexing Nested Complex Type Properties

EF Core 11 RC1 lets you declare indexes on properties nested inside complex types directly in the model. The author checks the resulting PostgreSQL plans with Npgsql and shows where indexing into JSON-mapped data still falls short. A practical read for .NET developers designing data models with complex types.

Deleting 18 Million Rows in Azure SQL Without Downtime

Mitchel Sellers describes how he purged over 18 million historical rows from an S1-tier Azure SQL database by deleting small, committed batches instead of one large statement. The article covers batch sizing, clustered-key range selection, supporting indexes and production monitoring. It is a practical guide for any .NET developer planning a large data cleanup on a shared database.

Read your own writes with Marten: ProjectLatest and Wolverine's UpdatedAggregate

Jeremy D. Miller explains how to read your own writes in event-sourced systems that use async projections in Marten. Switching from FetchLatest to ProjectLatest removes an extra database round trip by reusing pending events in the session. Wolverine's UpdatedAggregate type then lets HTTP endpoints and message handlers return the current aggregate with less code.