Getting the Best Out of Entity Framework Core

Explore the inner workings of Entity Framework Core (EF Core) to optimize database access in C# applications. Gain insights into querying techniques, relationship handling, unit testing strategies, and Domain-Driven Design implementation. Discover the changes introduced in EF Core 3, including Cosmos DB integration. Learn how to write more efficient database access code by understanding EF Core's internal processes, from basic database operations to advanced concepts like relational fixup and soft delete. Dive into practical examples, including a super-simple database demonstration, various querying methods, and the SQL generated by EF Core. Enhance your skills in configuring EF Core through code and leverage ValueConversions for improved data handling.

Intro
Entity Framework Core in Action
A super-simple database to show how EF Core works
Three types of relationships
Three (four) ways of reading the database
A look at the Select load code
The SQL created by the Select query
A better way to set up the relationships
EF Core works out the correct order for the SQL
Understanding relational fixup
Relational fixup and hierarchical data
EF Core and Domain-Driven Design in 5 minutes
An example of a DDD-styled entity class
Alternative to Delete - soft delete
ValueConversions (came in EF Core 2.1)
Using code to configure EF Core
Using Cosmos DB to improve performance
Cosmos DB-in EF Core 3 (some limitations)
Unit testing applications that user EF Core
The end