The Entity Framework Core tooling can be used to create the C# files that represent an existing database. In section, Phil covers scaffolding a database with the EF Core tooling, and then scaffolds the AdventureWorks 2016 database. The final step is to add the remaining prebuilt classes into the data access layer project.
- [Instructor] The EF Core Tooling…is divided into three main areas:…There's Database commands.…This'll drop or update the database,…and it's typically used with migrations.…The DbContext.…This allows us to list, get info about…or scaffold a new DbContext.…And then there's Migrations.…And this is how we take our POCOs and…convert them into the database.…You can run the commands two different ways.…Either through the .NET Command Light Interface.…
This is the same interface I use to restore…the packages with dotnet restore.…So we just type in dotnet ef and then the commands.…If you want to get help you can do -h or --help.…You can also run all the commands from PowerShell,…and they have the typical PowerShell syntax…update-database, scaffold-dbcontext, et cetera.…To scaffold a database, we simply type in…dotnet ef dbcontext and scaffold.…
This tells the commands we want to scaffold a dbcontext.…And we have to feed it a data source and a provider.…Data Source for me is localdb, mssqllocaldb.…I'm going to call the catalog AdventureWorks2016.…
- Entity Framework Core components and projects
- Working with scaffolded files
- Testing with xUnit
- Viewing generated SQL
- Composing queries
- Sorting and filtering results
- Working with aggregates
- Loading related data
- Logging and tracking
- Mapping functions
- Generics and delegates
- Checking concurrency
- Resiliency and transactions
Skill Level Intermediate
Learning Entity Framework Corewith Reynald Adolphe1h 35m Intermediate
1. Get to Know Entity Framework
2. Set the Stage
3. Querying Data: Part 1
4. Querying Data: Part 2
5. Advanced Query Features
6. Persisting Data
7. DbContext Options and Configuration
Thank you1m 23s
- 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.