.NET Programming With Me
Connection Pooling with Npgsql and .NET 8: PgBouncer, Multiplexing, and Best Practices
Connection pooling is more critical with PostgreSQL than it is with SQL Server, and the reason is architectural. Each PostgreSQL client co...
Sunday, May 24, 2026
Indexing Strategies in PostgreSQL That Every .NET Developer Should Know
Most .NET developers let EF Core generate their PostgreSQL indexes and then wonder why certain queries are slow in production. The default...
Full-Text Search in PostgreSQL from a .NET 8 EF Core Controller API
Adding keyword search to an API often leads .NET developers toward Elasticsearch or Azure Cognitive Search before they have even looked at...
JSONB Columns in PostgreSQL with EF Core: When and How to Use Them
PostgreSQL's jsonb column type is not a glorified text field for stashing serialised strings. It is a binary-indexed, queryable, firs...
PostgreSQL vs. SQL Server: What .NET Developers Need to Know Before Switching
You have shipped .NET APIs backed by SQL Server for years, and the next project lands with a PostgreSQL requirement. Or maybe your team is...
Boxing and Unboxing in C#: The Silent Performance Tax You Might Be Paying
Boxing and unboxing are two of the most common sources of silent, hard-to-diagnose performance regressions in .NET applications. They do n...
Wednesday, April 29, 2026
Versioning Your ASP.NET Core API Without Breaking Existing Clients
Sooner or later every API that has real consumers needs to change in ways that are not backward-compatible. You rename a field, remove a p...
Friday, April 24, 2026
Subscribe to: Posts (Atom)