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

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

(**Fill in the blank.**) EF Core records every applied migration in a table called ________.

(Fill in the blank.) EF Core records every applied migration in a table called ________.

By adding them to the `Up` and `Down` methods of the migration

By including them in the `migrations add` command

By including them as properties in the `context` class

By adding them to the `OnModelCreating` method

How does EF Core become aware of the entity types?

How does EF Core become aware of the entity types?

(**Fill in the blank.**) The SQL method of the `MigrationBuilder` class ________.

(Fill in the blank.) The SQL method of the <code>MigrationBuilder</code> class ________.

compressing migrations without losing data

(**Fill in the blank.**) Squashing is a process for ________.

(Fill in the blank.) Squashing is a process for ________.

defining entity relationships in the context class

(**Fill in the blank.**) In an existing or legacy database, it is advisable to start with ________.

(Fill in the blank.) In an existing or legacy database, it is advisable to start with ________.

Quiz Yourself on Migrations

Quiz Yourself on Migrations

Review what you’ve learned about migrations.

Getting Started

Reverse Engineering

Migrations

Configuring a Model

Query Data

Save Data

Logging and Testing

Conclusion

Appendix

Quiz: Migrations