data access
PostgreSQL for C# and .NET Articles, Tutorials & News
PostgreSQL for C# and .NET articles, tutorials, and news from the DotNetNews archive.
65 articles Updated Page 2 of 3
Browse additional PostgreSQL for C# and .NET articles from the DotNetNews archive.
PostgreSQL for C# and .NET articles
Page 2 of 3
Newest first
-
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.
-
How to Optimize SQL Queries: 20 Proven Best Practices
Dev Tips 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# Corner 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# Corner 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 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 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 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
Microsoft Dev Blogs 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 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
C# Digest Issue #432
not every AI feature needs a dedicated vector database
-
Getting Started With PgVector in .NET for Simple Vector Search
Milan's .NET Weekly 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
Milan's .NET Weekly 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
Dev Tips 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
Microsoft Azure 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
Visual Studio Magazine 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 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# Corner 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
Milan's .NET Weekly 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 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…