Join Richard Goforth for an in-depth discussion in this video Creating an inhertance relationship, part of Accessing Existing Databases with Entity Framework Core.
- [Narrator] Sometimes it makes sense to consider a table…to represent more than one type.…Often, in existing databases, there's a column or several…columns, that are only applicable for some of the rows.…We can use an inheritance relationship in code to segment…those columns and have separate types holding these fields.…This is called Table Per Hierarchy Relational Mapping.…Inheritance won't be set up by the scaffolding process,…we have to manually set it up.…Let's navigate to the product model.…We can see on our product model the perishable property.…
We see these two columns, ExpirationDays and Refrigerated.…These columns only apply if a product is perishable.…Let's separate perishable products from regular products.…We'll start by copying the product model…and renaming it to PerishableProduct.…Let's copy that so we can paste it a couple more places.…In the PerishableProduct file,…we'll replace Product with PerishableProduct.…PerishableProduct will extend Product.…We can now delete all the Product properties.…
- Setting up your project
- Connecting to a legacy database
- Scaffolding an initial model and context
- Improving the model
- Updating properties and indexes
- Adding concurrency tokens and timestamps
- Creating complex relationships
- Working with non-Microsoft databases such as SQLite and PostgreSQL
Skill Level Intermediate
SQL Server 2014 Essential Trainingwith Martin Guidry3h 51m Intermediate
Microsoft SQL Server 2014: Backup and Recoverywith Martin Guidry1h 22m Intermediate
1. Get Started with EF Core: On Your Legacy Database
2. Improve the Model
3. Model Complex Relationships
4. Work with Non-Microsoft Databases
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.