SAHASRA TECHNOLOGIES
Beginner to intermediate curriculum · Entity Framework Core — Optional TrackEntity Framework Core — Optional Track
Optional ORM learning kept separate from the core SQL + ADO.NET + Dapper path so students understand database operations before abstraction.
- Duration
- 14–18 classes
- Per class
- 90 minutes
Curriculum PDF: save the complete Entity Framework Core — Optional Track syllabus for offline reference.
Learning objective
Use EF Core for common CRUD and relationship scenarios without diving into advanced internals.
Recommended class plan
14–18 classes · 90 minutes per class
2–3 classes per week
Technologies
- Entity Framework Core
- C#
- LINQ
- SQL Server
Tools
- Visual Studio
- .NET CLI
- NuGet
- SSMS
Curriculum modules
Basic Foundations → Practical Skills → Guided Application
- 1
ORM & DbContext
ORM concepts, packages, DbContext, DbSet, entities and connection configuration.
- 2
Code First & Migrations
Create a model, generate migrations and update a development database.
- 3
CRUD & LINQ
Query, insert, update and delete entities with practical LINQ.
- 4
Relationships & Tracking
Basic relationships, Include, change tracking and common update patterns.
Beginner topics
Start Here and Build Comfort
- ORM concept
- DbContext and DbSet
- Entities
- Code First
- Migrations
- Basic CRUD
Intermediate topics
Progress After the Basics Are Clear
- Relationships
- Include
- Tracking basics
- LINQ filters and projections
- Updating disconnected data basics
Practical learning
Practise, Submit, Build and Explain
Practical exercises
- Create a Code First model
- Run migrations
- Build CRUD queries
- Load related data
Assignments
- Add EF Core to a small API
- Compare one Dapper query with EF Core
Mini projects
- EF Core Student Records API
Industry habits throughout the track
Terminology, Debugging and Responsible AI
Industry terminology
- ORM
- Entity
- DbContext
- DbSet
- Migration
- Tracking
- Relationship
Debugging exercises
- Fix a migration mismatch
- Investigate missing related data
- Resolve a tracking conflict
AI learning exercises
- Ask AI to explain generated migration code
- Review an EF query for unnecessary loading
Topics intentionally excluded
Advanced Topics Come Later
Quality fundamentals are more valuable than an overloaded syllabus. These topics are outside this track:
- Advanced EF Core internals
- Complex performance tuning
- Advanced interceptors
- Distributed transactions
Recommended next track