Join Richard Goforth for an in-depth discussion in this video Adding and altering indexes, part of Accessing Existing Databases with Entity Framework Core.
- [Instructor] Indexes are invaluable when looking up data…in a database that is of any significant size.…While most existing databases have some indexes…already set up, it is common to find a query that is…relatively inefficient, and significant improvement…could be added with a new index.…Let's look at some ways we can handle indexes…in the Entity Framework Core.…By convention, indexes are automatically created for each…property or property group that compose a foreign key.…Let's look at the indexes that we already have…on the Order table.…Under the model folders, we'll open the context,…and scroll down to the Orders table.…
We can see on the Order table that…we have an index for the OrderDate.…We also have indexes on the foreign keys…for the table, by convention.…The CutomerId and the SalespersonId…both have indexes defined by convention.…Let's look at the snapshot file in the Migrations folder…to see these indexes defined explicitly.…We'll scroll down to the definition of the Orders table.…At the bottom of this definition,…
- 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.