Scaffold-DbContext multiple Schemas with specific tables

Question

I have a single database that has multiple schema's. The two schemas are Bob and Bill. Both Bob and Bill contain Table1 Table2 and Table3. When I call Scaffold-DbContext it to just generate scaffold for Table1, Table2, Table3 for a single schema "Bob" which is what I thought I would run this command.

Scaffold-DbContext -t Table1 Table2 Table3 -schema "Bob"

When I run that command I get all tables in the database including Table1, Table2, Table3 from Both Schema's why is this and what can I do to just get a single schema and Table1, Table2, Table3

The right argument is -schemas "Bob" - see scaffold-dbcontext — 5andr0
– 5andr0, Commented Dec 6, 2024 at 17:37

ErikEJ · Accepted Answer · 2021-05-25 10:24:14Z

5

Use only -t option with schema.tablename syntax

answered May 25, 2021 at 10:24

ErikEJ

42.1k5 gold badges81 silver badges119 bronze badges

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

2 Comments

Micah Armantrout Over a year ago

Thank-you so much! This is a life saver!

Ak777 Over a year ago

for multiple schemas, and specific tables, how would i go about it? right now, i am trying this but it get ALL the tables from the mentioned schemas.

Scaffold-DbContext "My-postgresql-connectionstring" Npgsql.EntityFrameworkCore.PostgreSQL -o DbModels  -UseDatabaseNames -Force -Context "PgDbContext" -Schema "schema1", "schema2" -t schema1.table1, schema1.table2, schema2.table11, schema2.table22

. What am i doing wrong and where is it going wrong?

iCollect.it Ltd · Accepted Answer · 2021-11-08 12:25:12Z

3

To be clear, multiple table names should also be comma separated:

Scaffold-DbContext -t Bob.Table1, Bob.Table2, Bob.Table3

If any table name contains spaces (somethings out of our control), quote the table name as well:

Scaffold-DbContext -t "Bob.Table 1", "Bob.Table 2", "Bob.Table 3"

answered Nov 8, 2021 at 12:25

iCollect.it Ltd

93.9k26 gold badges189 silver badges210 bronze badges

Collectives™ on Stack Overflow

Scaffold-DbContext multiple Schemas with specific tables

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related