Roadmap › 1. .NET › Step 15
EF
Entity Framework (EF6 & EF Core)
DbContext, code-first and database-first, conventions and Fluent API, relationships, migrations, querying and loading strategies, change tracking, concurrency, transactions, performance tuning and EF6 vs EF Core.
Interview priority:★ Must know High priority — asked in almost every interview, learn firstMedium asked regularlyLow good to know
Module 1: Getting Started
- 1.What an ORM is, and EF6 vs EF CoreBasic ★ Must know
- 2.DbContext, DbSet and configurationBasic ★ Must know
- 3.Code-first vs database-first and migrationsBasic ★ Must know
- 4.Conventions, data annotations and Fluent APIBasic ★ Must know
Module 2: Relationships and Modelling
- 5.One-to-one, one-to-many, many-to-manyIntermediate ★ Must know
- 6.Owned types, complex types, value conversions and inheritanceIntermediate Medium
Module 3: Querying
- 7.Querying, tracking vs no-trackingBasic ★ Must know
- 8.Loading related data: eager, explicit, lazyIntermediate ★ Must know
- 9.Raw SQL, stored procedures and bulk operationsIntermediate ★ Must know
Module 4: Saving Data
- 10.Add, update, delete and SaveChangesBasic ★ Must know
- 11.Concurrency controlIntermediate ★ Must know
- 12.TransactionsIntermediate ★ Must know
Module 5: Performance and Advanced
- 13.EF Core performance checklistAdvanced ★ Must know
- 14.Global query filters, interceptors, shadow properties and temporal tablesAdvanced Medium
- 15.Testing code that uses EF CoreIntermediate Medium
Next course in the roadmap: 16. Dapper — The Micro-ORM from Basics to Advanced →