Home>Courses>Using Entity Framework Core for Data Access & Relational Mapping

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

Course Overview

What You'll Learn

Course Content

Recommendations

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

The ability to configure a model using Entity Framework Core

Course Content

Getting Started

2 Lessons

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

Introduction to Entity Framework Core

Features of Entity Framework Core

Reverse Engineering

5 Lessons

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

8 Lessons

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

11 Lessons

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

14 Lessons

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.

Adding, Updating, and Deleting Data

Change Tracking

Disconnected Entities

Quiz: Save Data

Challenge: Save Data

Challenge Solution: Save Data

Logging and Testing

6 Lessons

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

Logging with Entity Framework Core

Filtering Logs in Entity Framework Core

Quiz: Logging

Testing with SQLite

Testing with the Repository Pattern

Quiz: Testing

Conclusion

1 Lessons

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

Wrap Up!

Appendix

1 Lessons

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

Installing Entity Framework Core

Course Author

Emmanuel Okpukpan

Trusted by 2.5 million developers working at companies

"These are high-quality courses. Trust me. I own around 10 and the price is worth it for the content quality. EducativeInc came at the right time in my career. I'm understanding topics better than with any book or online video tutorial I've done. Truly made for developers. Thanks"

Anthony Walker

@_webarchitect_

"Just finished my first full #ML course: Machine learning for Software Engineers from Educative, Inc. ... Highly recommend!"

Evan Dunbar

ML Engineer

"You guys are the gold standard of crash-courses... Narrow enough that it doesn't need years of study or a full blown book to get the gist, but broad enough that an afternoon of Googling doesn't cut it."

Carlos Matias La Borde

Software Developer

"I spend my days and nights on Educative. It is indispensable. It is such a unique and reader-friendly site"

Souvik Kundu

Front-end Developer

"Your courses are simply awesome, the depth they go into and the breadth of coverage is so good that I don't have to refer to 10 different websites looking for interview topics and content."

Vinay Krishnaiah

Software Developer

"I've tried probably 5-7 different sites and Educative is easily the best. It perfectly blends explanation with interactivity"

Eric Downs

Musician/Entrepeneur

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!

Recommended before starting this course

Course

Learn C#

This course introduces the basics of C# programming. It is an ideal resource for beginners aiming to become C# developers.

beginner

8 hours

Course

An Introductory Guide to SQL

Gain insights into SQL by exploring database creation, data manipulation, and advanced queries. Learn about practical applications and practice for SQL interviews to build confidence and readiness.

beginner

An Introductory Guide to SQL

beginner

13 hour

Related Courses and Skill Paths

Course

Getting Started with LINQ in C#

Gain insights into LINQ in C#, learn about lambda expressions, explore common LINQ methods, avoid pitfalls, and refactor code to be more expressive and efficient.

intermediate

4 hours 20 mins

Course

Querying Databases Using Transact-SQL

Gain insights into T-SQL syntax, table creation, data manipulation, and relationships. Delve into advanced constructs like stored procedures, functions, and triggers to enhance your database development skills.

intermediate

15 hours

Course

Deep Dive into the Internals of the Database

Gain insights into database internals, explore their structure, architecture, and functionality. Learn about efficient distribution, crucial transaction features, and optimal data structures for various models.

advanced

19 hours

Course

Getting Started with LINQ in C#

intermediate

4 hour 20 min

Course

Querying Databases Using Transact-SQL

intermediate

15 hour

Course

Deep Dive into the Internals of the Database