Entity Framework Core For Data Access And Relational Mapping

Using Entity Framework Core for Data Access & Relational Mapping

Beginner

54 Lessons

15h

Certificate of Completion

Entity Framework Core is a modern, lightweight, open-source, cross-platform object-relational mapper.

AI-POWERED

Explanations

Explanations

This course includes

117 Playgrounds

8 Quizzes

34 Illustrations

This course includes

117 Playgrounds

8 Quizzes

34 Illustrations

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

Course Content

1

Getting Started

Introduction to Entity Framework Core

Features of Entity Framework Core

2

Reverse Engineering

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

3

Migrations

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

4

Configuring a Model

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

5

Query Data

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

6

Save Data

6 Lessons

7

Logging and Testing

6 Lessons

8

Conclusion

1 Lesson

9

Appendix

1 Lesson

COURSE AUTHOR

How You'll Learn

You don’t get better at swimming by watching others. Coding is no different. Practice as you learn with live code environments inside your browser.

Videos are holding you back. Educative‘s interactive, text-based lessons accelerate learning — no setup, downloads, or alt-tabbing required.

Learn faster and smarter with adaptive AI tools embedded in every Educative course.

Built-in assessments let you test your skills. Completion certificates let you show them off.

Recommended Courses

BEFORE STARTING THIS COURSE

AFTER FINISHING THIS COURSE

FOR TEAMS

Interested in this course for your business or team?

Unlock this course (and 1,000+ more) for your entire org with DevPath