Sign in to confirm you’re not a bot
This helps protect our community. Learn more

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

dotnet
324K subscribers
<__slot-el>
<__slot-el>
13K views Streamed 2 years ago #orm #entityframework #efcore
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. Community Links: https://www.theurlist.com/dotnet-data... Featuring: Arthur Vickers (@ajcvickers) Get your questions answered on the Microsoft Q&A for .NET - https://aka.ms/dotnetqa ​ Learn .NET with free self-guided learning from Microsoft Learn: http://aka.ms/learndotnet #entityframework #efcore #orm ...more
...more
.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. Community Links: https://www.theurlist.com/dotnet-data... Featuring: Arthur Vickers (@ajcvickers) Get your questions answered on the Microsoft Q&A for .NET - https://aka.ms/dotnetqa ​ Learn .NET with free self-guided learning from Microsoft Learn: http://aka.ms/learndotnet #entityframework #efcore #orm

Follow along using the transcript.

dotnet

324K subscribers