FROM TABLE TO TWIN

Have you ever opened the database behind a system you thought you understood, and found two answers where you expected one? You recognize the tables — Unit, Signal, WorkOrder — but then you hit a folder of EF Core migrations that doesn't quite match the SQL someone else wrote by hand, a DbContext with shadow foreign keys nobody named, and a quiet, nagging question: which one of these is actually telling the truth about my data?

From Table to Twin is written specifically to answer that question.

Unlike most Entity Framework books, which hand you a DbContext on page one and never look back, this book takes a deliberately two-path approach. You build the same industrial schema twice — once by hand in SQL Server, reverse-engineered into C#; once from C# with Code First, generating its own migrations — and then you put the two builds side by side. Where Scaffold-DbContext and Fluent API disagree on naming, shadow keys, and inferred relationships, this book doesn't pick a winner and move on. It prints the disagreement, in a dedicated reconciliation chapter, and shows you which one to trust and when.

Try the Live Software Demo Now!

This book is a hands-on, deeply integrated companion guide to NEXUS-1, the same fully interactive, browser-based digital-twin console used throughout the series — except this volume is the one that finally writes down where all of it actually lives.

No server, no installation, and zero setup required. Open the console, and every schema named in this book, every query quoted, and every row counted can be counted again, live, in your browser:

👉 Play with the Live Console: https://gregory82gr.github.io/Nexus-1-phase-0/

What's Under the Hood? (The Schema Blueprint)

This is not a toy Blog/Post sample database. The companion book walks the literal data backbone of an industrial nuclear-plant digital twin — a schema plausibly past two hundred tables, built to the same standard throughout:

• One schema, seventeen bounded contexts. Reactor Fleet, Instrumentation, Alarm Management, Digital Twin, Root Cause Analysis, Reinforcement Learning, and the rest — every sector the first three NEXUS-1 volumes already wrote to, finally given a single, coherent home.
• Two builds, one model. Part 1 authors the database by hand in SQL Server — schemas, keys, indexes, constraints, views — then reverse-engineers it with Scaffold-DbContext. Part 2 rebuilds the identical model from C#: configuration classes, value converters, owned types, and generated migrations.
• The uniform lookup-table generator. Rather than forty near-identical CREATE TABLE listings, the book teaches one shape, one SQL generator, and one generic IEntityTypeConfiguration<T> — and proves it in an appendix that lists every table the generator actually produced.
• Advanced relationships, taken seriously. Owned types, table-per-type inheritance for equipment hierarchies, many-to-many joins, alternate keys — modelled the way an industrial schema actually needs them, not the way a tutorial simplifies them.
• Audit, history, and performance, with evidence. Soft delete with query filters, SQL Server temporal tables, RowVersion concurrency — then indexes measured the honest way, with logical reads and execution plans shown before and after, never asserted from memory.
• Beyond the ORM. A dedicated appendix on Dapper, SqlBulkCopy, and raw SQL — and the harder discipline of knowing the handful of places in a two-hundred-table schema where EF Core is genuinely the wrong tool.

How Every Chapter Is Structured

To keep sixteen chapters of database design from turning into a wall of DDL, every chapter follows the same five-beat scaffold the NEXUS-1 series has used since Volume I:

1. What You Already Know: The bridge from engineering instincts you already have — a bounded context is just a SQL schema with a passport; a foreign key is just the passport between them.
2. The Concept: A clear, prose explanation of the modelling decision, never a checklist of EF Core features for their own sake.
3. See It in NEXUS-1: Direct guidance on exactly where that table, that index, or that migration is live on your console screen.
4. Try It: Something to actually run — add a Status row and watch it appear without a redeploy; run a migration twice and watch nothing break.
5. Honest Boundary: A transparent account of what the model simplifies, defers, or deliberately does not claim — because nothing in this book claims to exist that does not.

👤 Who This Is For

This book assumes you're already fluent in C#, comfortable in .NET, and at home in SQL Server. It does not assume you want a guided tour of Entity Framework's feature list — that is not what this book is. If you've ever inherited a database you didn't trust, scaffolded a model you couldn't quite read, or wondered whether your Code First migrations and your DBA's hand-written schema actually agree with each other, this is the book that walks you through finding out — on a real, running reference you can open and check for yourself.

Author: Grigorios Kyriakos Agathangelidis
Greek name: Γρηγόριος Κυριάκος Αγαθαγγελίδης
Also searchable as: Αγαθαγγελίδης Γρηγόριος, Αγαθαγγελιδης Γρηγοριος, Grigorios Agathangelidis.