How to get only specific tables to create models from database with Entity Framework Core in C#

Question

I'm using Scaffold-DbContext to create models from an existing database, but it auto pluralizes the table names and I don't want that. It also gets all the tables but I need only a couple of them.

Is there a way to disable pluralization and select only some specific tables with that command?

If code generati1on has already taken you to 90%, you might as well copy the couple of tables and their DB context mappings in a file and forget about the scaffold. — R J
– R J, Commented Apr 2, 2022 at 7:42

Bani · Accepted Answer · 2023-08-26 10:07:58Z

7

Use

Scaffold-DbContext "[connection string here from database properties]" Microsoft.EntityFrameworkCore.SqlServer -OutputDir "path where your context should be created" -Tables ["tablename1","tablename2"] -NoPluralize

You can read this documentation for more information but this should get the job done.

edited Aug 26, 2023 at 10:07

answered May 18, 2022 at 11:42

Bani

5725 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marc_s · Accepted Answer · 2022-04-02 07:51:11Z

3

If you have a look at the official documentation - you'd see:

Scaffold-DbContext

Parameters

...

Tables <String[]> - The tables to generate entity types for. If this parameter is omitted, all tables are included.

...

NoPluralize - Don't use the pluralizer. Added in EF Core 5.0.

So yes - both of your requests can be handled with parameters to Scaffold-DbContext - just consult the docs!

answered Apr 2, 2022 at 7:51

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Collectives™ on Stack Overflow

How to get only specific tables to create models from database with Entity Framework Core in C#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related