data access
PostgreSQL for C# and .NET Articles, Tutorials & News
PostgreSQL for C# and .NET articles, tutorials, and news from the DotNetNews archive.
61 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# Corner 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# Corner Issue #492
Compare PostgreSQL vs SQL Server for .NET apps.
-
We Moved from SQL Server to PostgreSQL in a .NET
Medium 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 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 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
Milan's .NET Weekly 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
Visual Studio Magazine 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 3
Newest first
-
Can PostgreSQL Keep Up When Thousands of AI Agents Query It at Once?
C# Corner - Ananya Desai Issue #557
-
PostgreSQL to SQL Field Notes: Date & Time
Microsoft Dev Blogs - Jerry Nixon Issue #554
Welcome to SQL First, welcome to SQL! You're going to like this. Upgrading from PostgreSQL is real work, and depending on your old PostgreSQL, that process ca
-
Making POST Requests Idempotent in .NET 8: Preventing Duplicate Requests in Distributed Systems
Medium - Adeboye Salisu Issue #552
A practical look at how I used idempotency keys, EF Core and PostgreSQL unique constraints in Taskora to make retries safe under…
-
Getting Started With Event Sourcing in .NET With Marten and PostgreSQL
Medium - Anton Martyniuk Issue #550
Most applications store data by saving the current state to a database. Continue reading on CodeX »
-
Adding an Index Made This Query Slower
Milan's .NET Weekly Issue #546
A query already had a usable index. Adding another index made Postgres choose a plan that discarded almost half a million rows to return ten.
-
Let Postgres Enforce Tenant Isolation
Milan's .NET Weekly Issue #542
EF Core query filters can be bypassed. PostgreSQL row-level security enforces tenant isolation on reads and writes, if you connect with the right database role…
-
10 Rare SQL Features Every Developer Should Know
Dev Tips Issue #541
Senior developers reach for SQL features most juniors never learn. Here are 10 powerful PostgreSQL features - CTEs, window functions, LATERAL joins, FILTER, UPSERT, JSON, generated columns, and more -
-
PostgreSQL 19 WAIT FOR LSN: Solving Read-Your-Writes Consistency in .NET
C# Corner Issue #535
Learn how PostgreSQL 19 WAIT FOR LSN helps solve read-your-writes consistency in .NET applications using logical replication, WAL positions, and controlled database reads.
-
PostgreSQL 19 Beta 3: Testing Temporal Tables with EF Core
C# Corner Issue #533
Learn how to test PostgreSQL 19 Beta 3 temporal tables with EF Core, including temporal queries, compatibility testing, and potential query behavior changes.
-
PostgreSQL 19 SQL/PGQ: Building Property Graph Queries with .NET
C# Corner Issue #533
Learn how PostgreSQL 19 SQL/PGQ enables property graph queries and explore how .NET applications can model relationships, traverse graphs, and query connected data.
-
PostgreSQL 19 Beta 3: Testing Temporal Table Queries with EF Core
C# Corner Issue #531
Explore PostgreSQL 19 temporal table capabilities with EF Core and test temporal queries, historical data access, performance, and .NET integration.
-
PostgreSQL 19 Beta: Benchmarking JSONB Workloads from .NET APIs
C# Corner Issue #529
Benchmark PostgreSQL 19 Beta JSONB workloads from .NET APIs and evaluate query performance, indexing strategies, EF Core behavior, and database scalability.
-
From 17ms to 0.04ms: How to Design the Right SQL Index
Milan's .NET Weekly Issue #528
What does a good SQL index look like? I seeded Postgres with 1 million comments and measured every indexing decision with EXPLAIN ANALYZE: a 17ms sequential…
-
What Actually Happens When React Calls a .NET API?
Medium Issue #528
Following one API request from a React button click to PostgreSQL and back.
-
PostgreSQL 19 Beta: Benchmarking JSONB Indexes with EF Core
C# Corner Issue #528
Benchmark PostgreSQL 19 Beta JSONB indexes with EF Core by measuring query performance, indexing strategies, execution plans, storage, and application response times.
-
Benchmarking PostgreSQL 19 Beta Planner Changes with EF Core
C# Corner Issue #527
Benchmark PostgreSQL 19 Beta query planner changes with EF Core using realistic workloads, execution plans, query latency, throughput, and database performance metrics.
-
PostgreSQL 18 OAuth Authentication with ASP.NET Core Identity
C# Corner Issue #524
PostgreSQL 18 OAuth integrates with ASP.NET Core Identity for secure database authentication, enhancing layered security without replacement.
-
Benchmarking PostgreSQL 18 AIO with Real EF Core Workloads
C# Corner Issue #523
Benchmark PostgreSQL 18 AIO with EF Core workloads. Measure impact on ASP.NET Core apps, storage I/O, and query performance.
-
PostgreSQL 18 AIO: Benchmarking .NET Database Workloads
C# Corner Issue #520
Benchmark PostgreSQL 18 AIO with .NET workloads. Measure performance differences between sync, worker, and io_uring for optimal database I/O.
-
Relational Where It Helps, JSONB Where It Must: Persisting IIIF Presentation 3 in PostgreSQL with…
Medium Issue #519
A proof of concept using the real IIIF Manifest object model, EF Core owned entities, Razor Pages, PostgreSQL, and careful JSONB
-
ASP.NET Web API CRUD with EF Core & PostgreSQL (Code First)
C# Corner Issue #517
Build an ASP.NET Core Web API with EF Core and PostgreSQL using Code First. Master CRUD operations for robust data management.
-
Vector Databases with .NET: PostgreSQL pgvector vs Azure AI Search vs Qdrant
C# Corner Issue #516
Compare PostgreSQL pgvector, Azure AI Search, and Qdrant for .NET AI apps. Choose the best vector database for RAG, semantic search, and more.
-
PostgreSQL 18 Performance Tuning for EF Core Applications
C# Corner 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 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# Corner Issue #505
Build intelligent search apps with PostgreSQL pgvector & ASP.NET Core. Understand meaning, not just keywords, for better user experiences.