.NET Data Community Standup - TPH, TPT, and TPC Inheritance mapping with EF Core

Показать описание

Type inheritance hierarchies as used in object-oriented programming do not map naturally to relational database schemas. In this live stream, we will look at different strategies for inheritance mapping when using EF Core with a relational database. This includes table-per-hierarchy (TPH) mapping, table-per-type (TPT) mapping, and table-per-concrete type (TPC) mapping, which is new in EF Core 7.0 preview 5. We will look at the consequences of the mapping on the generated SQL and consider the performance and storage implications. This will result in some guidance as to when each strategy should be used.

#entityframework #efcore #orm

dotnet

Рекомендации по теме

Комментарии

00:56:53 TPC tables can use unique sequence ID by using the following.
.Property(e => VALUE FOR [AnimalIds]");

01:08:00 TPH tables can use IsSparse() to reduce the space of null data, but Perf. may be sacrified.
01:24:12 TPH tables may use Discriminator as Enum to improve the perf.
01:26:34 TPC tables can use UseHiLo() with SQL. SQL-Lite does not support UseHiLo().
01:30:13 The reason to use "await context.AddRangeAsync()" is UseHiLo().
01:33:00 HiLo confuses a lot of people because of the keys-gap .
01:35:00 Arthur recommended not using HiLo for simplicity.
01:37:25 If you update one raw at a time, you don't need HiLo.

PanosKao

how about I want a unique index in some value of the base table (in TPC) ?

AnNguyen-doec

Is it still necessary to define a sequence for the Id field when using TPC stratgey in EF Core 8? Thanks!

malkythealky

Where can I find an working example doing this ? Like a small project ?

johanredander

I still do not understand how Human.FavoriteAnimal navigation will get the right Animal type, you guys just touched the point that there is no foreign key constraint between Human and Animal which is a natural limitation that comes with TBC, but how does ef handle the navigation?! are we going to left join all child tables?

mhDuke

A varchar discriminator column hurts performance. Either use char(1) or a numeric value.

alexisfibonacci

.NET Data Community Standup - TPH, TPT, and TPC Inheritance mapping with EF Core

.NET Data Community Standup - Entity Framework Core FAQs

.NET Data Community Standup - Window and binary functions using Zomp EF Core extensions

.NET Data Community Standup: EF Core keys and value generation

.NET Data Community Standup - EF Core Internals – Model Building

.NET Data Community Standup - A Whirlwind Tour of EF7

.NET Data Community Standup - Database concurrency and EF Core - Episode 1

.NET Data Community Standup - EF7 Custom Model Conventions

.NET Data Community Standup-Improve your SQL schema and scripts with .NET based static code analysis

.NET Data Community Standup: All about EF Core property mapping

.NET Data Community Standup - Software version and 'stuff'

.NET Data Community Standup - Azure SQL Database and SQL Server 2022: what’s new for developers...

.NET Data Community Standup - Building Distributed Applications - Hot Chocolate, Aspire, & EF Co...

.NET Data Community Standup - A tour of what's new in EF8

.NET Data Community Standup - Database concurrency and EF Core: Beyond optimistic concurrency - Ep 3

.NET Data Community Standup - Performance Improvements to the EF7 Update Pipeline

.NET Data Community Standup - Complex types as value objects in EF8

.NET Data Community Standup - New CLI edition of EF Core Power Tools

.NET Data Community Standup - CoreWCF: Roadmap and Q&A

.NET Data Community Standup - EF Core Architecture: Internal Dependency Injection

.NET Data Community Standup - DbDataSource, a new System.Data abstraction

.NET Data Community Standup - EF Core internals: IQueryable, LINQ and the EF Core query pipeline

Entity Framework Community Standup - Introducing EF Core Compiled Models

.NET Data Community Standup - Intercept this EF7 Preview 6 Event

.NET Data Community Standup - JSON Columns