Using Entity Framework Core for Data Access & Relational Mapping

Discover Entity Framework Core for efficient data access and relational mapping. Gain insights into workflows, model configuration, querying, change tracking, logging, and testing to boost productivity and code maintainability.

Beginner

54 Lessons

15h

Certificate of Completion

AI-POWERED

Explanations

AI-POWERED

Explanations

This course includes

117 Playgrounds

8 Quizzes

This course includes

117 Playgrounds

8 Quizzes

Course Overview

This course introduces Entity Framework Core for data access and object-relational mapping. Entity Framework Core provides benefits such as the ability to work with databases using .NET objects without the concern for underlying database tables. This leads to less code for data access and improved performance. You’ll begin with the workflows of Entity Framework Core—reverse engineering and migrations. Next, you’ll learn model configuration and relationships. Then, you’ll cover various methods for querying...Show More

What You'll Learn

The ability to configure a model using Entity Framework Core

The ability to keep a model that’s always in sync with the database

Hands-on experience on querying data using Entity Framework Core

An understanding of change tracking and its relationship with queries

Hands-on experience with diagnosing SQL queries using Entity Framework Core

Familiarity with core testing techniques in Entity Framework Core

What You'll Learn

The ability to configure a model using Entity Framework Core

Course Content

Getting Started

Get familiar with Entity Framework Core essentials, setup, features, and data operations.

Introduction to Entity Framework Core

Features of Entity Framework Core

Reverse Engineering

Get started with reverse engineering databases by scaffolding and modifying models using EF Core.

Scaffolding a Model from a Database Schema Reviewing and Modifying the Scaffolded Model Quiz: Reverse Engineering Challenge: Reverse Engineering Challenge Solution: Reverse Engineering

Migrations

Examine migration management, production practices, data model changes, seeding, handling errors, and practical challenges.

Introduction to Migrations Using Migrations in a Production Database Modifying the Data Model Data Seeding and Custom Migrations Handling Mistakes and Avoiding Pitfalls Quiz: Migrations Challenge: Migrations Challenge Solution: Migrations

Configuring a Model

Apply your skills to configure EF Core models, entity types, properties, and relationships.

Conventions in Entity Framework Core Supplementing Conventions in Entity Framework Core Configuring Entity Types Configuring Entity Properties Relationships in Entity Framework Core Configuring One-to-Many Relationships Configuring One-to-One Relationships Configuring Many-to-Many Relationships Quiz: Configuring a Model Challenge: Configuring a Model Challenge Solution: Configuring a Model

Query Data

Deepen your understanding of querying data using LINQ, joins, and loading related data in EF Core.

Querying Data with LINQ LINQ Query Operations Filtering and Ordering Operations Projection and Grouping Query Operations Partitioning and Element Operations Quantifier and Aggregation Operations Loading Related Data Equi join Operations Custom Join Operations Raw SQL Queries and Split Queries Global Query Filters Quiz: Query Data Challenge: Query Data Challenge Solution: Query Data

Save Data

6 Lessons

Implement data addition, updating, and deletion in Entity Framework Core efficiently.

Logging and Testing

6 Lessons

Practice using logging and testing techniques in Entity Framework Core effectively.

Conclusion

1 Lesson

Gain a comprehensive overview of Entity Framework Core's features, workflows, and key topics.

Appendix

1 Lesson

Walk through installing Entity Framework Core and setting up essential tools and packages.

Course Author

Trusted by 1.4 million developers working at companies

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Evan Dunbar

ML Engineer

Carlos Matias La Borde

Software Developer

Souvik Kundu

Front-end Developer

Vinay Krishnaiah

Software Developer

Eric Downs

Musician/Entrepeneur

Kenan Eyvazov

DevOps Engineer

Anthony Walker

@_webarchitect_

Emma Bostian 🐞

@EmmaBostian

Hands-on Learning Powered by AI

See how Educative uses AI to make your learning more immersive than ever before.

Instant Code Feedback

Evaluate and debug your code with the click of a button. Get real-time feedback on test cases, including time and space complexity of your solutions.

AI-Powered Mock Interviews

Put your skills to the test in a simulated interview setting. Receive personalized feedback based on your performance. Available in Premium & Premium Plus plans.

Adaptive Learning

At various checkpoints throughout Educative courses, you will be prompted to take a quick assessment. Receive a condensed curriculum tailored to your strengths and skill gaps.

Explain with AI

Select any text within any Educative course, and get an instant explanation — without ever leaving your browser.

AI Code Mentor

AI Code Mentor helps you quickly identify errors in your code, learn from your mistakes, and nudge you in the right direction — just like a 1:1 tutor!