data access
PostgreSQL for C# and .NET Articles, Tutorials & News
PostgreSQL for C# and .NET articles, tutorials, and news from the DotNetNews archive.
50 articles Updated Page 2 of 2
Browse additional PostgreSQL for C# and .NET articles from the DotNetNews archive.
PostgreSQL for C# and .NET articles
Page 2 of 2
Newest first
-
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…
-
Boost Your EF Core Productivity in PostgreSQL With Entity Developer
antondevtips.com 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.com 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.com 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…
-
Build your own Static Code Analysis tool in .NET by knowing how Assembly, Type, MethodInfo, ParameterInfo work.
code4it.dev Issue #254
Why buy a whole tool when you can build your own? Learn how the Type system works in .NET, and create your own minimal type analyser.
-
Postgres Full Text Search with EF Core 9
medium.com Issue #223
https://medium.com/@vosarat1995/postgres-full-text-search-with-ef-core-9-40da6805033e
-
Data Access in ASP.NET Core: Combining Dapper, EF Core, and PostgreSQL
medium.com Issue #184
https://medium.com/@aamritbistaa/data-access-in-asp-net-core-combining-dapper-ef-core-and-postgresql-77e2e20615c0
-
Building a .NET 9 Web API with Entity Framework Core and PostgreSQL
semihtekin.medium.com Issue #148
https://semihtekin.medium.com/building-a-net-9-web-api-with-entity-framework-core-and-postgresql-103bd666917f
-
How To Deploy .NET Application to Azure using Neon Postgres and .NET Aspire
antondevtips.com Issue #142
https://antondevtips.com/blog/how-to-deploy-dotnet-application-to-azure-using-neon-postgres-and-dotnet-aspire
-
gRPC, EF Core seeding, and C# delegates
DotNetNews Issue #120
A varied .NET roundup with gRPC in .NET 8, EF Core 9 seeding, source generators, Blazor styling, LINQ performance, and WinForms debugging.
-
Azure Functions, CDC, and profiling
DotNetNews Issue #110
A varied .NET roundup covering serverless scaling, PostgreSQL CDC, Visual Studio benchmarking, .http API testing, caching, and C# fundamentals.
-
ORM choices and ASP.NET lessons
DotNetNews Issue #102
A varied .NET roundup with ORM comparisons, ASP.NET MVC security, REST API mistakes, runtime debugging, docs automation, and GitHub safety.
-
ASP.NET APIs, EF Core, and .NET 9 tips
DotNetNews Issue #79
Issue #79 covers ASP.NET API styles, EF Core with PostgreSQL, .NET 9 LINQ and caching, plus C# performance and JSON tips.
-
JSON, AI, and ASP.NET Core tips
DotNetNews Issue #77
Issue #77 covers JSON choices, unit testing, OpenAI and Azure AI, ASP.NET Core middleware, Swagger, DDD, Blazor, and Cosmos DB tools.
-
ASP.NET Core, .NET 9 and Azure
DotNetNews Issue #7
A varied set of .NET reads: middleware, Web API CRUD, SOLID basics, Visual Studio 17.12, GitHub Actions packaging, Azure migration, and .NET 9 tips.