ErikEJ.EFCorePowerTools.Cli 7.0.0

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 operating system with the .NET 6.0 / .NET 8.0 runtime installed.

For a quick intro you can watch this 2 minute demo video.

Installing the tool

EF Core 8:

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

EF Core 7:

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

EF Core 6:

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

Running the tool

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

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

Type efcpt --help for help on command line options.

The provider name (mssql) may not be required, as an attempt is made to resolve the provider from the connection string.

Configuring 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. For reference there is a fully populated sample file here.

Updating to new configuration

After updating the efcpt-config.json, you will need to run the efcpt CLI command from above once again in order to update the generated code.

If you have updated the configuration file in a way that requires files to be deleted - by excluding objects for example - then you will need to set the "soft-delete-obsolete-files" option in the configuration file to true or delete the files manually.

Excluding objects

The config file will always contain all current database objects.

You can exclude indvidual database objects with "exclude": true for the object.

You can also use the exclusionWildcard item under each type of data object to filter included objects.

You can use the following filter expressions:

• *: Exclude all objects in section. Overrides all other filters.
• abc*: Exclude all objects in section that starts with abc. Multiple filters allowed.
• *xyz: Exclude all objects in section that ends with xyz. Multiple filters allowed.
• *mno*: Exclude all objects in section that contains mno. Multiple filters allowed.

Filters will apply unless "exclude": false is explicitly set for a database object.

All filters are case sensitive.

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

In the example above, only the Users table will be selected.

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

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

Updating the tool

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

Release notes - notice the +CLI label.

Integration with Visual Studio Code

The tool adds a number of project specific task in a .vscode/tasks.json file.

Theses tasks can be run from the command palette in VS Code. Select Tasks: Run Task and then select the task you want to run.

The tasks are:

• EF Core Power Tools: Reverse Engineer - runs the tool with the current provider and connection string.
• EF Core Power Tools: Edit Configuration - opens the configuration file in the editor.
• EF Core Power Tools: Update - updates the tool to the latest version.

In addition, when editing the configuration file, you get tooltips, IntelliSense suggestions and validation of the file format.