#ef-core

Articles tagged with #ef-core

EF Core - Deployment: SQL Script Generation
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...
Dec 30, 20255 min read4
Entity Framework Core - TransactionScope
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...
Dec 25, 20255 min read1
Entity Framework Core - Transaction & Rollback
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...
Dec 25, 20255 min read
EF Core: Mapping & Constraints via Data Annotations
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...
Dec 19, 20255 min read4
Entity Framework Core Setup Guide
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 ...
Dec 19, 20254 min read2