Join Richard Goforth for an in-depth discussion in this video Solution: Product recall, part of Accessing Existing Databases with Entity Framework Core.
- [Instructor] Now that you've had a chance…to work on your own solution, let me show you…how I solved the product recall challenge.…I started by getting a list of the customers…who ordered the faulty product.…For each customer I wanted to check if any of their…orders had any item that matched the recall.…Here I used where the collection of orders…has any order item that have the product ID…that matches our recalled product.…Next I printed the list of customers to the screen…after ordering them by last name…and using the distinct extension method…to eliminate any duplicates.…
Let's go ahead and run the program.…We now have a clean list of customers…that we can call and notify about the recall.…
- 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?
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.