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

Previously, we saw how to retrieve and save entities using the same instance of a `DbContext`. This lesson reviews how to save disconnected entities. **Disconnected entities** refer to entities queried using one `DbContext` and saved using another `DbContext`.


The illustration above demonstrates attaching a disconnected entity to the context using the appropriate `EntityState`.

> **Note:** The outputs from the projects in this lesson contain the results of the sample codes and logs from the translated SQL queries used.

# Identifying new entities
Recall that EF Core automatically sets up value generation for primary keys. This feature is useful when determining if an entity needs to be inserted or updated. If a key has a value, then the entity was previously saved and now needs updating. Otherwise, it is new and requires inserting.

# Adding single entities

The project below demonstrates adding single entities to a context:


Learn the basics of adding or updating disconnected entities and graphs.

Getting Started

Reverse Engineering

Migrations

Configuring a Model

Query Data

Save Data

Logging and Testing

Conclusion

Appendix

Disconnected Entities