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 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
-
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…
-
Updating and Deleting Tasks in Our .NET
Medium Issue #300
In the previous post, we created new tasks and got our backend to communicate with PostgreSQL. By including Update (PUT) and Delete…
-
Boost Your EF Core Productivity in PostgreSQL With Entity Developer
Dev Tips Issue #272
Model-First approach: instead of hand-writing your models and configurations, you design them visually. Continue reading on CodeX »
-
Database Indexing in .NET with EF Core — Boost Your Query Performance
Medium Issue #272
Learn how to improve query performance in your .NET applications using database indexing with Entity Framework Core. Includes examples…
-
Building a High-Performance API with .NET and PostgreSQL
Medium Issue #269
When I started building APIs, I thought: “If it works, it’s good.” Then came my first production issue: API calls that took forever. I…