EF Core database model first - take it to the next level with Power Tools CLI
summary
Generates a DbContext and entity classes from a live database in seconds using a .NET global tool published on NuGet, with a demo that actually produces compilable code after adding the recommended provider packages. Maps tables, views, stored procedures and functions (with warnings for dynamic result sets), recognizes SQL Server types like hierarchyid when extended libraries are added, outputs a mermaid ER diagram, and cleans removed files to the recycle bin so regeneration is safe and repeatable.
AI-written summary · about
chapters (12)
- 0:00EF Core and Power Tools intro
- 1:05What is EF Core
- 5:22EF Core releases
- 8:55EF Core 9 features
- 13:14Database-first workflow
- 16:11Setup Power Tools CLI
- 21:13Generate code from DB
- 24:08Code generation config
- 27:54Advanced customization
- 34:30Generating documentation with Mermaid diagrams
- 39:10DACPAC modeling
- 41:26Q&A migrations
related talks
47mEF Core 6: Working on the Bucket List
01h 01m10 things you didn't know EF Core can do
59mEF Core 6: Fulfilling the Bucket List
44m10 things you didn't know EF Core can do
43mEF Core 8 overview and demo
43mEF Core 9: Evolving Data Access in .NET
59m10 things you didn't know EF Core can do
01h 10mModern Data Applications with Entity Framework 7