data access
PostgreSQL for C# and .NET Articles, Tutorials & News
PostgreSQL for C# and .NET articles, tutorials, and news from the DotNetNews archive.
39 articles Updated
PostgreSQL C# is the focus of this topic page. PostgreSQL for C# and .NET is part of the data-access layer most .NET apps rely on, whether the store is relational or document-oriented. Intermediate and senior .NET developers use this hub to scan practical writing without treating every link as an endorsement.
Recurring subtopics in recent issues include PostgreSQL C#, PostgreSQL .NET, Npgsql, and EF Core PostgreSQL. Those themes are drawn from titles and excerpts in the newest archive entries for this tag, not from a marketing outline.
Expect publisher tutorials, release notes, architecture write-ups, and field notes linked from DotNetNews issues. Start here is a short editorial shortlist for PostgreSQL for C# and .NET; the archive list is chronological and larger. Secondary angles such as PostgreSQL C# and PostgreSQL .NET appear when the archive actually covered them. Nearby reading often overlaps with Entity Framework Core and Dapper for C# and .NET.
Start here
Editor picks for PostgreSQL
-
Implementing Long-Term Memory for AI Agents with Semantic Kernel and PostgreSQL
c-sharpcorner.com Issue #500
Long-term memory is where many agent demos become actual applications; PostgreSQL makes this feel more grounded.
-
PostgreSQL vs SQL Server for Modern .NET Applications
c-sharpcorner.com Issue #492
Compare PostgreSQL vs SQL Server for .NET apps.
-
We Moved from SQL Server to PostgreSQL in a .NET
medium.com Issue #483
Real migration writeups are always more useful than abstract comparisons, especially when they include cost and operational reasons.
-
The Interval Is the Thing: Modelling Range Types as First-Class Domain Objects in .NET
medium.com Issue #476
Interesting domain modeling piece, especially for teams pairing rich types with PostgreSQL range support.
-
PostgreSQL Like a Pro: Build mission-critical apps at any scale with Azure HorizonDB
youtube.com Issue #439
This one leans cloud and data platform, with useful context for scaling PostgreSQL on Azure and thinking through hosting choices for AI agents.
-
Getting Started With PgVector in .NET for Simple Vector Search
milanjovanovic.tech Issue #423
pgvector in PostgreSQL is a nice reminder that vector search doesn’t have to mean a new database.
-
Supercharging GenAI Apps with PostgreSQL and Azure AI
visualstudiomagazine.com Issue #381
PostgreSQL plus Azure AI is a strong combo here, especially with PGVector and VS Code extensions in the mix.
-
Is Redis Overkill? Rethink SignalR Backplane with PostgreSQL
levelup.gitconnected.com Issue #314
Using PostgreSQL as a SignalR backplane is a smart reality check when Redis would be more infrastructure than you need.
Archive
Page 1 of 2
Newest first
-
PostgreSQL 18 Performance Tuning for EF Core Applications
c-sharpcorner.com Issue #514
Optimize PostgreSQL 18 for EF Core apps. Learn to tune queries, use indexes, manage data loading, and implement a repeatable performance tuning process.
-
WSLC Meets Compose: Running a Full .NET 10 Stack Without Docker Desktop
medium.com Issue #512
A practical multi-container workflow for .NET 10, PostgreSQL, and Redis on Windows.
-
Building Semantic Search Applications with PostgreSQL pgvector and ASP.NET Core
c-sharpcorner.com Issue #505
Build intelligent search apps with PostgreSQL pgvector & ASP.NET Core. Understand meaning, not just keywords, for better user experiences.
-
How to Optimize SQL Queries: 20 Proven Best Practices
antondevtips.com Issue #505
Slow queries drag down every app. Learn 20 proven techniques to optimize SQL queries in PostgreSQL - indexes, covering indexes, sargable filters, smarter joins, materialized views, functions in where,
-
Implementing Long-Term Memory for AI Agents with Semantic Kernel and PostgreSQL
c-sharpcorner.com Issue #500
Unlock AI's potential with long-term memory using Semantic Kernel & PostgreSQL. Build context-aware, personalized agents.
-
PostgreSQL vs SQL Server for Modern .NET Applications
c-sharpcorner.com Issue #492
Compare PostgreSQL vs SQL Server for .NET apps. Explore licensing, performance, cloud, JSON, and scalability to choose the best fit.
-
We Moved from SQL Server to PostgreSQL in a .NET
medium.com Issue #483
We moved one of our .NET systems from SQL Server to PostgreSQL mainly to reduce licensing cost and simplify our cloud setup.
-
The Interval Is the Thing: Modelling Range Types as First-Class Domain Objects in .NET
medium.com Issue #476
A complete solution: expressive range types in your domain layer, full PostgreSQL translation in your data layer — no compromises at…
-
ASP.NET Core 10 Web API CRUD with EF Core - Complete .NET 10 Tutorial
codewithmukesh.com Issue #473
Build a production-ready .NET 10 Web API with EF Core 10 and PostgreSQL. CRUD operations, DDD, Minimal APIs, Scalar, code-first migrations, and best practices.
-
High-Performance Distributed Caching with .NET and Postgres on Azure
devblogs.microsoft.com Issue #449
Adding caching to your application architecture can significantly improve key performance metrics, cut latency, and reduce load across downstream systems. In this walkthrough, we highlight the latest ...
-
Just Use Postgres as a Queue?
codeopinion.com Issue #443
I’ve noticed a trend, and a lot of people are saying the same thing: just use Postgres as a queue. No Kafka, no Redis, no RabbitMQ, just one database for everything. And I totally get it. I get the ap...
-
PostgreSQL Like a Pro: Build mission-critical apps at any scale with Azure HorizonDB
youtube.com Issue #439
Choosing the Right Azure Hosting Model for AI Agents: A Deep Dive into Foundry Hosted Agents
-
Getting started with PgVector in .NET for simple vector search
csharpdigest.net Issue #432
not every AI feature needs a dedicated vector database
-
Getting Started With PgVector in .NET for Simple Vector Search
milanjovanovic.tech Issue #423
Vector search doesn't require a dedicated vector database. PostgreSQL with pgvector gives you similarity search right next to your relational data. Here's how to set it up in .NET with Aspire, Dapper,...
-
Optimizing Bulk Database Updates in .NET: From Naive to Lightning-Fast
milanjovanovic.tech Issue #415
Seven approaches to bulk-updating rows in PostgreSQL from .NET using Dapper and EF Core, from naive per-row updates to binary COPY. Each step cuts down on round-trips or removes dynamic SQL entirely.
-
How to Set Up Production-Ready Monitoring With ASP.NET Core Health Checks
antondevtips.com Issue #401
Learn how to build a production-ready monitoring system using ASP.NET Core Health Checks. This guide covers adding health checks for Postgres, Redis, MongoDB, and MassTransit (RabbitMQ), creating cust
-
PostgreSQL on Azure supercharged for AI
azure.microsoft.com Issue #387
From GitHub Copilot AI assistance to built-in model management, Azure is helping devs and enterprises unlock the full potential of PostgreSQL. The post PostgreSQL on Azure supercharged for AI appeare...
-
Supercharging GenAI Apps with PostgreSQL and Azure AI
visualstudiomagazine.com Issue #381
Learn how to supercharge your GenAI apps with PostgreSQL and Azure AI. Lino Tadros shows how PGVector and AI Extensions in VS Code turn PostgreSQL into an intelligent foundation for high-performance G...
-
Easier Query Models with Marten
jeremydmiller.com Issue #381
The Marten community made our first big release of the new year with 8.18 this morning. I'm particularly happy with a couple significant things in this release: We had 8 different contributors in just...
-
⚡ Extremely FAST Paging With Cursor Pagination & Index Seek
medium.com Issue #342
SQL Server • PostgreSQL • MySQL • MongoDB Compared — with Full .NET 9 Code (Part 1)
-
Is Redis Overkill? Rethink SignalR Backplane with PostgreSQL
levelup.gitconnected.com Issue #314
Redis isn’t always the right fit. Here’s how PostgreSQL can serve as a backplane for SignalR in distributed, low-throughput applications. Continue reading on Level Up Coding »
-
Dapper + Entity Framework Core (EF Core) together against PostgreSQL in .NET 8
c-sharpcorner.com Issue #304
Combine the power of Entity Framework Core (EF Core) for schema management and Dapper for raw SQL performance in .NET 8 with PostgreSQL. This guide explores two approaches: using EF Core for CRUD and ...
-
Using Stored Procedures and Functions With EF Core and PostgreSQL
milanjovanovic.tech Issue #301
Learn how to use PostgreSQL stored procedures and functions with EF Core to handle complex queries, atomic operations with locking, and database-specific features while keeping the type safety and con...
-
Stop Fighting EF Core: How to Use Stored Procedures and Functions (The Right Way)
medium.com Issue #301
You’re building a .NET application with EF Core. Most of your queries work fine with LINQ, but now you’re hitting scenarios where you need…
-
Updating and Deleting Tasks in Our .NET
medium.com Issue #300
In the previous post, we created new tasks and got our backend to communicate with PostgreSQL. By including Update (PUT) and Delete…