ErikEJ.EFCorePowerTools.Cli 6.0.0-preview5

EF Core Power Tools CLI

Cross platform command line tool for advanced EF Core reverse engineering. See the full guide explaining all the features here.

Getting started

The tool runs on any computer with the .NET 6.0 runtime installed.

Install the tool

For EF Core 7:

dotnet tool install ErikEJ.EFCorePowerTools.Cli -g --version 7.0.*-*

For EF Core 6:

dotnet tool install ErikEJ.EFCorePowerTools.Cli -g --version 6.0.*-*

Run the tool

From the folder where you want the code to be generated (usually where your .NET project is located)

efcpt "Server=(local);Database=Northwind;User id=user;Pwd=secret123;Encrypt=false" mssql

Configure options

A configuration file efcpt-config.json is created in the output folder, and you can open this file in your editor to modify the default options. If your editor supports it (for example VS Code), it will provide syntax guidance for the file.

Update the tool

dotnet tool update ErikEJ.EFCorePowerTools.Cli -g --version 7.0.*-*

Excluding objects

The config file will always contain all current database objects. You can use the exclusionWildcard item under each type of data object to filter included objects.

You can use the following filter expressions:

• abc*: Starts with.
• *xyz: Ends with.
• *: Exclude all unless "exclude": false is explicitly set.

All filters are case sensitive.

"tables": [
      {
         "exclusionWildcard": "*"
      },
      {
         "name": "[dbo].[Users]",
         "exclude": false
      },
      {
         "name": "[dbo].[Accounts]",
         "exclude": false
      },
      {
         "name": "[dbo].[Messages]"
      },
      {
         "name": "[dbo].[Payments]"
      }
  ],

In the example above, only Users and Accounts tables will be selected.