PostgreSQL Migration, Async, Authorization
Coverage includes a .NET move to PostgreSQL, async and cancellation guidance, custom ASP.NET Core auth, EF Core auditing, and caching.
Jasen's top three picks
- 1 We Moved from SQL Server to PostgreSQL in a .NET
medium.com
Real migration writeups are always more useful than abstract comparisons, especially when they include cost and operational reasons.
- 2 Understand .NET ConfigureAwait(), .Result and await
medium.com
Still a worthwhile topic because async mistakes in .NET usually show up as reliability problems later.
- 3 Building Custom Role-Based Authorization in ASP.NET Core Using Attributes and Middleware
medium.com
Useful for teams that have outgrown simple policy checks and need something more tailored.
Editor's note
I put together another intentionally mixed issue today, with a few pieces that solve very practical problems. The PostgreSQL migration story stands out because it gets into cost and cloud tradeoffs, and the async coverage around ConfigureAwait, .Result, and CancellationToken is the kind of material that keeps production code out of trouble. I also liked the custom ASP.NET Core authorization article and the EF Core audit logging piece for their day-to-day usefulness.
Today's articles
We Moved from SQL Server to PostgreSQL in a .NET
medium.com
We moved one of our .NET systems from SQL Server to PostgreSQL mainly to reduce licensing cost and simplify our cloud setup.
Topics: .NET Core PostgreSQL SQL Server
Read article
Understand .NET ConfigureAwait(), .Result and await
medium.com
Imagine you’re going to a bank to file some paperwork.
Topics: C# Performance
Read article
Building Custom Role-Based Authorization in ASP.NET Core Using Attributes and Middleware
medium.com
Controlling access to different parts of an application is one of the most important aspects of application security. While ASP.NET Core…
Topics: ASP.NET Core Authorization Security
Read article
Intro to Durable Functions: Orchestrations and the Chaining Pattern
medium.com
An order comes in, and you need to validate it, create it, then send a confirmation, three steps that have to run in order and survive a…
Topics: Azure Azure Functions
Read article
Workshop: Build a Console Menu in C#
medium.com
A hands-on recipe for wiring up a do/while loop, a switch statement, and real product data into a working interactive console app.
Topics: C#
Read article
Building AI-Powered Release Validation Systems Using ASP.NET Core
c-sharpcorner.com
Build AI-powered release validation systems with ASP.NET Core for smarter, safer, and more reliable software deployments.
Topics: ASP.NET Core OpenAI
Read article
♂️ BONUS! Modernizing .NET — Part 29: Bonus Round with System.Web Request and Response Wrappers
medium.com
Use HttpRequest and HttpResponse wrappers to keep legacy System.Web code moving during an ASP.NET Core migration.
Topics: ASP.NET Core .NET Framework
Read article
New lines are more than and
meziantou.net
When we talk about new lines, most developers think about (Windows) and (Unix-like systems). That works most of the time, but it is not the full picture. Unicode and several regex engines reco...
Topics: C#
Read article
Why Senior .NET Developers Never Use string.Split — And What They Use Instead
medium.com
A practical deep dive into zero-allocation C# for developers who want to write production-grade code Continue reading on CodeToDeploy »
Topics: C# Performance
Read article
CancellationToken in C# Async/Await: The Complete Guide
medium.com
If you have written more than a handful of async methods in C#, you have run into a method signature like this:
Topics: C# Performance
Read article
Stop Making Your Database Sweat: A Step-by-Step Guide to Caching
medium.com
“Why on earth did it take so long to fetch that data?!”
Topics: Performance
Read articleBuilding AI-Powered Data Validation Pipelines in ASP.NET Core
c-sharpcorner.com
Build intelligent AI-powered data validation pipelines in ASP.NET Core to enhance data quality, detect anomalies, and reduce manual reviews.
Topics: ASP.NET Core OpenAI
Read articleStop Hand-Rolling Audit Logs in EF Core
iamrzr.medium.com
Every team that touches regulated data eventually has the same meeting. Someone from compliance asks a deceptively simple question: who…
Topics: EF Core
Read article
.NET MAUI APIs You Should Stop Using Before .NET 11
medium.com
As .NET 11 continues to evolve, it’s a great opportunity for .NET MAUI developers to modernize their codebases. While many existing APIs…
Read article
Why DbContext Is Scoped and Not Singleton
medium.com
Understanding dependency injection lifetime, thread safety, and the unit-of-work pattern in Entity Framework
Topics: EF Core
Read article
Modernising Legacy .NET Applications Without a Rewrite
medium.com
Most legacy .NET applications don’t need a rewrite — they need a plan.
Topics: ASP.NET Core Clean Architecture .NET Framework
Read article
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
medium.com
GUID v7 in SQL Server: Performance Benefits, Limitations, and Best Practices
Topics: Performance SQL Server
Read article
AWS Secrets Manager in .NET: How To Load Your Secrets Straight into IConfiguration
medium.com
If you build .NET apps that run on AWS, you have probably lived this moment. A connection string, an API key, maybe a signing secret, all…
Topics: Azure
Read articleHuman Resource Management System in ASP.NET Core MVC – Part 3
c-sharpcorner.com
Complete your ASP.NET Core MVC HRM with role-based dashboards, insightful reports, and robust deployment strategies for enterprise readiness.
Topics: ASP.NET Core Authorization ASP.NET MVC
Read article