Feb 3 · 13 min read · Use EF Core when you want a full ORM that boosts productivity and long-term maintainability (LINQ, change tracking, migrations, cross-database providers). Use Dapper when you want maximum SQL control and minimal overhead, especially for read-heavy or...
Join discussion
Jan 27 · 1 min read · If you’re learning .NET, here’s a roadmap that actually leads to real skills. What we built A Todo API with: REST endpoints (GET/POST/PUT/DELETE) Middleware (logging + global errors) Dependency Injection Swagger EF Core + SQLite persistence Int...
Join discussionJan 27 · 2 min read · Right now our todos disappear when the app stops — because we’re storing them in memory. Let’s make it real:✅ EF Core✅ SQLite (simple local database file)✅ async database calls Step 1 — Add EF Core packages dotnet add package Microsoft.EntityFramewo...
Join discussionDec 30, 2025 · 5 min read · 1. Overview The Idempotent SQL Script strategy involves generating a plain text SQL file that contains all database migration logic. Unlike standard SQL scripts, an idempotent script wraps every migration step in conditional logic (e.g., IF NOT EXIST...
Join discussionDec 25, 2025 · 5 min read · TransactionScope in Entity Framework Core Namespace: System.Transactions Assembly: System.Transactions.Local (Nuget package typically included with .NET Core) 1. Overview TransactionScope provides an implicit, ambient transaction model. Unlike explic...
Join discussionDec 25, 2025 · 5 min read · Transactions are the mechanism that ensures data integrity: they guarantee that a series of database operations either all succeed or all fail (Atomicity). In Entity Framework Core (EF Core), transaction management ranges from fully automatic to high...
Join discussionDec 21, 2025 · 10 min read · This article was originally published on my blog. "Where Did Database First Go?" If you were using Entity Framework when EF Core first dropped, you probably remember the moment you went looking for database-first support and found... nothing. EF Cor...
Join discussionDec 19, 2025 · 5 min read · Data Annotations are attribute-based configurations applied directly to entity classes and properties. They serve two purposes: defining the database schema (DDL) and providing runtime validation for ASP.NET Core. Namespaces Required: using System.Co...
Join discussionDec 19, 2025 · 4 min read · Entity Framework Core (EF Core) is the standard open-source ORM for .NET applications. This guide covers the installation, configuration, and architectural patterns used in enterprise-grade production environments. 1. Prerequisites & Installation EF ...
Join discussion
