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.

Using Entity Framework Core for Data Access & Relational Mapping.png

ScaffoldDB.tar.gz

EFCore

EFCorePreCreateTablesInOutputDir

EFCorePreCreateTablesAndViewInOutputDir

EFCoreWithProxies

EFCoreWithXunit

CreateSchoolTablesInOutputDir

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.

Using Entity Framework Core for Data Access & Relational Mapping

# Overview
In real-world projects, data models get updated as features get implemented. New entities or properties get added and removed. Migrations provide a means to update the database schema and keep it in sync with the model. This approach is known as the Code First workflow because the EF Core model is the source of truth.

> **Note:** The commands in this lesson generate code and files. Through the terminal, we can navigate to these files by using relevant Linux commands such as `ls` to view a list of files and directories, `cd` to change directories, and `cat` to view file contents. A SPA widget showing the updated project with the generated files is also available. Also, note that EF Core uses a timestamp within the generated file names. We represent these names with `xxx`.

# Creating and applying migrations

A migration is a point-in-time snapshot of the data model. EF Core generates migration source files based on the differences between shots.

> **Note:** It’s good practice to keep the changes between migrations small. This practice helps to keep track of the changes during development, prevents mistakes, and makes it easier to reverse those changes.

To demonstrate migrations, we’ll be working with the C# project below:

Learn how to create migrations and update a database with them.

Getting Started

Reverse Engineering

Migrations

Configuring a Model

Query Data

Save Data

Logging and Testing

Conclusion

Appendix

Introduction to Migrations

Overview

Creating and applying migrations