How to add schema name to entity names?

[ClassyCircuit]

This is not a bug, this is a question - how do I include the schema name when generating entities?
For example, Prd.Store is currently generated as Store.cs, but I want it to be named Prd_Store.cs

How do I accomplish this? And I don't really want to specify each table manually, since I have over 400 tables that should follow this pattern: {schema}_{tableName}.cs

[ErikEJ]

I think you can use the renaming feature: https://github.com/ErikEJ/EFCorePowerTools/wiki/Reverse-Engineering#custom-renaming-with-efptrenamingjson (combine "UseSchemaName" with a regex)

[ErikEJ]

Also, having 400 tables in a single DbContext will cause you pain.

[ClassyCircuit]

They are split across multiple contexts, so it's more like 40-50 tables per one dbcontext.

What does the "UseSchemaName" flag do? I don't see any examples where it's being used.

[ClassyCircuit]

I don't understand how to use the regex feature, I followed the example in linked issue, and this is what I came up with:

[
  {
    "UseSchemaName": true,
    "SchemaName": "Fact",
    "TableRegexPattern": "^.+$",
    "TablePatternReplaceWith": "Fact_$0"
  }
]

But it doesn't rename anything.

[ErikEJ]

It includes the schema name in the property name - try it out!

[ErikEJ]

Start with the example in the linked PR

[ClassyCircuit]

I used the sample that user e-ngin wrote 4 days ago:

{
  "UseSchemaName": false,
  "SchemaName": "dbo",
  "TableRegexPattern": "^.+$",
  "TablePatternReplaceWith": "$0Entity"
}

I just replaced "dbo" with "Fact", and also added the missing square brackets, so in the end it looks like this:

[
  {
    "UseSchemaName": true,
    "SchemaName": "Fact",
    "TableRegexPattern": "^.+$",
    "TablePatternReplaceWith": "$0Entity"
  }
]

Then I regenerated entities, but they weren't renamed. Am I missing anything in the file?

[ErikEJ]

There could be a bug, please use the exact same parameters as in the PR first.

[ErikEJ]

If you still encounter issues, please share your renaming json file, and a sample create table script.

[ClassyCircuit]

I got it working :)
The issue was this flag, I had to disable it:

And if anyone else in the future needs this functionality, here is the config file I used:

[
  {
    "UseSchemaName": true,
    "SchemaName": "Prd",
    "TableRegexPattern": "^.+$",
    "TablePatternReplaceWith": "Prd$0"
  },
  {
    "UseSchemaName": true,
    "SchemaName": "Sales",
    "TableRegexPattern": "^.+$",
    "TablePatternReplaceWith": "Sales$0"
  },
  {
    "UseSchemaName": true,
    "SchemaName": "Order",
    "TableRegexPattern": "^.+$",
    "TablePatternReplaceWith": "Order$0"
  }
]

The only issue I am still encountering - after having disabled that flag, the tables are no longer named as they are in the database - the casings are now CamelCase, and underscores are removed. Which I don't really like, I prefer having 100% the same table name, only with prepended schema name to it.
Even if I explicility add the underscore in the "TablePatternReplaceWith", it is still removed afterwards.

But if that is difficult to fix, then I can live with it.

@ErikEJ thanks for the assistance!

[ErikEJ]

Great. I think the database names issue may be fixed in EF Core 5

[ErikEJ]

Where is the _ by the way?

[ClassyCircuit]

If you mean the regex part, then I added the underscore here:
"TablePatternReplaceWith": "Order_$0"
Result: "OrderItem.cs", should have been: "Order_Item.cs"

[ErikEJ]

I have linked your sample from the docs...