Welcome to the EntityFrameworkCore repository!
This project is designed to help you learn and understand Entity Framework Core (EF Core) in .NET 8 through practical, standalone console applications.
Each topic in EF Core is covered in its own independent console app, complete with shared data and example code to demonstrate real-world usage.
Whether you're a beginner or an experienced developer, this repository provides a hands-on way to:
- Study EF Core topics
- Revise key concepts
- Test knowledge by running modular apps
The repository is organized into separate folders, each containing a standalone .NET 8 console application.
Each app focuses on a specific EF Core topic, with reusable data and implementation examples.
- Introduction to setting up and getting started with EF Core.
- Concurrency
- External Configuration
- Internal Configuration
- DbContext Lifetime
- Using Context Factory
- Using Context Pooling
- Using Dependency Injection
- By Convention
- Override Configuration with Data Annotations
- Override Configuration with Fluent API
- Using Grouping Configuration
- Scaffolding database models with EF Core.
- Basic Setup
- Exclude Entity
- Include Entity
- Mapping View
- Code-First Approach
- Database-First Approach
- Using EF Core APIs to create and drop databases.
- Seeding initial data into the database.
- Client vs. Server Evaluation
- Tracking vs. No-Tracking Queries
- Related Data (Eager, Lazy, Explicit Loading)
- Split Queries
- Joins (Inner, Cross, Left Join)
- Select Many
- Group By
- Pagination
- Executing Raw SQL Queries
- SQL Query Parameters
- Calling Stored Procedures
- Calling User-Defined Functions
- Calling Database Views
- Calling Table-Valued Functions
- Global Query Filters
- Basic Save Operations
- Change Tracking
- Cascade Delete
- Efficient Updating
- Implementing and using EF Core interceptors.
To run the console applications in this repository, ensure the following:
- ✅ .NET 8 SDK: Download it here
- ✅ Database: Most applications use a local database (e.g., SQL Server or SQLite)
🕸️ Provided by SpiderX
Explore, practice, and strengthen your EF Core skills with confidence.
🔁 You're welcome to fork, clone, or contribute — your input can help others grow as well.
🤝 Let’s build something better, together.