遗留多表EF Database First应用转.NET Core API的EF Core工具适配问题

Hey there! I totally get your pain—moving from EF's classic EDMX wizard to EF Core's tooling can feel like losing a familiar safety net, especially when you're dealing with hundreds of tables and only need to add 1-2 at a time. Here are the most practical approaches to replicate that incremental update workflow:

1. 使用Scaffold-DbContext命令的表过滤功能 #

EF Core's reverse-engineering command lets you target specific tables instead of scaffolding the entire database every time. This is the closest command-line equivalent to the old "Update Model From Database" tool.

Run this in the Package Manager Console (or dotnet CLI) to scaffold only the tables you need:

# Package Manager Console
Scaffold-DbContext "YourDatabaseConnectionString" Microsoft.EntityFrameworkCore.SqlServer -Tables TableName1, TableName2 -OutputDir Models -Force

# Dotnet CLI
dotnet ef dbcontext scaffold "YourDatabaseConnectionString" Microsoft.EntityFrameworkCore.SqlServer --tables TableName1,TableName2 --output-dir Models --force

关键参数说明： #

• -Tables/--tables: 指定要生成模型的表（多个用逗号分隔）
• -OutputDir/--output-dir: 控制生成的实体类存放目录
• -Force/--force: 覆盖已存在的同名实体文件（如果之前生成过）

注意: 每次运行会重新生成整个DbContext文件，所以建议：

• 把自定义的DbContext配置（比如额外的方法、全局过滤）放在单独的部分类文件里，避免被覆盖
• 或者只生成实体类，手动添加DbSet<T>到你的现有DbContext中（可以通过添加-NoContext参数来只生成实体）

2. 使用EF Core Power Tools（可视化向导） #

If you prefer a GUI experience similar to the old EDMX tool, EF Core Power Tools is a must-have Visual Studio extension. It adds a right-click menu option to scaffold specific tables, and it handles incremental updates much more gracefully:

• Install the extension directly from Visual Studio's extension marketplace
• Right-click your project → EF Core Power Tools → Reverse Engineer
• Select your database connection, then pick only the tables you want to add/update
• Choose options like "Use fluent API only" or "Generate partial classes" to fit your workflow

This tool will generate only the selected tables' entities and update your DbContext (or add new DbSets if they don't exist) without overwriting your custom code.

3. 手动维护实体模型（适合少量表） #

For 1-2 tables at a time, sometimes manual setup is faster and more controllable:

• Create a new entity class matching the table schema (use DataAnnotations for simple mappings like [Key], [Column])
• Add a DbSet<YourEntity> to your existing DbContext
• Use Fluent API in OnModelCreating for more complex configurations (like relationships, indexes)

This avoids any auto-generated code conflicts and lets you tailor the model exactly to your needs.

额外建议 #

Since you're dealing with hundreds of tables, consider:

• Splitting your models into subfolders or even separate class libraries by domain module (e.g., Models/Customer, Models/Inventory)
• Using partial classes to keep auto-generated code separate from custom logic
• Keeping your EF Core version aligned with your database provider (e.g., SqlServer, PostgreSQL) to avoid compatibility issues

内容的提问来源于stack exchange，提问作者Alex