How can I scaffold with multiple schemas and particular table?

Question

I have two schemas Bob and Bill. I want to scaffold with schema Bob all tables and with schema Bill only View_Otf table.

If I use the following code, I get an empty DbContext:

dotnet ef dbcontext scaffold "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=something)(PORT=1533)))(CONNECT_DATA=(SERVICE_NAME=otherthing)));User ID=Bob;Password=anotherthing" Devart.Data.Oracle.Entity.EFCore -o Models -t Bill.View_Otf --schema Bob

If I use --schema Bob --schema Bill I get all tables from both schemas and I don't need that.

How can I get all the tables from schema Bob and the table Bill.View_Otf?

Thank you!

Answer 1

You will have to list all tables individually. Or you can try EF Core Power Tools, which has a UI for it.