Demos for blog posts abount Entity Framework Core

N+1 Queries Problem

See the method ExecuteDemoDbQueries in Program.cs

Blog posts:

• Entity Framework Core Performance: Beware of N+1 Queries
• Entity Framework Core 2.1 Performance: Beware of N+1 Queries (Revisited)

Inheritance

Blog posts:

• Entity Framework Core: Inheritance - Table-per-Type (TPT) is not supported, is it? (Part 1 - Code First)
• Entity Framework Core: Inheritance - Table-per-Type (TPT) is not supported, is it? (Part 2 - Database First)

Table-Per-Hierarchy (TPH)

Code First: see the method ExecuteTphQueries in Program.cs and the file in /src/EntityFramework.Demo/TphModel/CodeFirst

Table-Per-Type (TPT)

Code First: see the method ExecuteTptQueries in Program.cs and the file in /src/EntityFramework.Demo/TptModel/CodeFirst

Changing Schema at Runtime

See the method ExecuteSchemaChangeQueries in Program.cs

Blog posts:

• Entity Framework Core: Changing Database Schema at Runtime
• Entity Framework Core: Changing DB Migration Schema at Runtime

Issues with TransactionScopes

See the method ExecuteTransactionScopeDemosAsync in Program.cs

Blog posts: Entity Framework Core: Use TransactionScope with Caution!

Integration Testing

See code inside folder IntegrationTests

Blog posts: Entity Framework Core: Isolation of Integration Tests

Issues with RowVersion/Timestamp and NumberToBytesConverter

See method ExecuteRowVersionConversionDemos in Program.cs

Doing a LEFT JOIN with entities having a RowVersion on the right side may throw if using NumberToBytesConverter<T>.