In this video, I cover everything you need to master PostgreSQL with ASP.NET Core and Npgsql — from building CRUD APIs to advanced patterns like JSONB, connection pooling, and clean architecture.
✅ What you will learn:
— Setting up PostgreSQL with Docker Compose
— EF Core vs Dapper — when to use which
— Building a full CRUD API with Entity Framework Core
— Redis caching with Docker
— JSONB column mapping in PostgreSQL
— NpgsqlDataSource — the modern connection pattern
— Connection pooling and exception handling
— Identity for authentication in ASP.NET Core
— Clean Architecture + Dependency Injection best practices
— EF Core migrations for reliable database management
🔔 Subscribe to RandomlyEngineered for weekly videos on Software Engineering, AI, ASP.NET, BCS Exam Prep and ICT!
📌 Playlist: Engineer's Mindset — Software Engineering
#aspnetcore #postgresql #npgsql #dotnet #efcore #dapper #docker