HomeCoursesUsing Entity Framework Core for Data Access & Relational Mapping

4.3

Beginner

15h

Updated 3 months ago

Using Entity Framework Core for Data Access & Relational Mapping

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

Join 2.7 million developers at

Overview

Content

Reviews

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 and saving data. You’ll also learn about change tracking and its relationship with queries. Finally, you’ll learn about logging and testing. Entity Framework Core simplifies app development. By the end of this course, you’ll be able to improve code maintainability and concentrate on business logic by generating SQL, materializing results, and performing other tasks. You’ll have a good understanding of Entity Framework Core, which will improve your productivity and efficiency on your development journey.

This course introduces Entity Framework Core for data access and object-relational mapping. Entity Framework Core provides benef...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

Content

54 Lessons8 Quizzes

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

Build a REST API Using ASP.NET Core 6

Project

Premium

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

Certificate of Completion

Showcase your accomplishment by sharing your certificate of completion.

Course Author:

Collins Ushi

Developed by MAANG Engineers

Every Educative lesson is designed by a team of ex-MAANG software engineers and PhD computer science educators, and developed in consultation with developers and data scientists working at Meta, Google, and more. Our mission is to get you hands-on with the necessary skills to stay ahead in a constantly changing industry. No video, no fluff. Just interactive, project-based learning with personalized feedback that adapts to your goals and experience.

Trusted by 2.7 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."

Software Developer

Carlos Matias La Borde

"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

Hands-on Learning Powered by AI

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

Personalized Interview Prep

Skip the LeetCode grind with a custom roadmap that adapts to your goals. Hands-on practice for Coding Interviews, System Design, and more.

Mock Interviews

Test your skills in a simulated interview setting. Receive personalized feedback based on your performance. Available for Coding Interviews, System Design, and more.

AI Prompt

Build prompt engineering skills. Practice implementing AI-informed solutions.

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.

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!

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.

4 h 20 m

intermediate

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.

15 h

intermediate

Course

Deep Dive into the Internals of the Database

Gain insights into database internals, explore different database types, delve into their structures, and discover the data structures and transaction features essential for efficient data management.

19 h

advanced

Course

Learn C#

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

8 h

beginner

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.

13 h

beginner

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