EntityFrameworkRuler 1.3.42

Prefix Reserved
There is a newer version of this package available.
See the version list below for details.
dotnet tool install --global EntityFrameworkRuler --version 1.3.42                
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest # if you are setting up this repo
dotnet tool install --local EntityFrameworkRuler --version 1.3.42                
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=EntityFrameworkRuler&version=1.3.42                
nuke :add-package EntityFrameworkRuler --version 1.3.42                

Entity Framework Ruler - Command Line Tool

This is a dotnet command line tool and cannot be referenced directly from a project. Its main purpose is to generate a DB context rule file from an EDMX. The VS Extension can also do the same thing with a UI.


Automate the customization of the EF Core Reverse Engineered model. Features include:

  • Legacy EF6 (EDMX) migration support
  • Class renaming
  • Property renaming (including both primitives and navigations)
  • Type changing (useful for enum mapping)
  • Custom navigations that have no database foreign key, such as adding navigations to views
  • Table splitting (multiple entities using subsets of columns from the same table)
  • Entity inheritance (TPH, TPT, TPC)
  • Auto-naming tables and columns using regex
  • Skipping tables or columns
  • Forcing inclusion of simple many-to-many entities into the model
  • Entity type configuration file splitting

EF Ruler applies customizations from a rule document stored in the project folder. Rules can be initialized with a call to ef dbcontext scaffold, or they can be fully generated from an EDMX such that the scaffolding output will align with the old EF6 EDMX-based model.

"EF Ruler provides a smooth upgrade path from EF6 to EF Core by ensuring that the Reverse Engineered model maps perfectly from the old EDMX structure."


Upgrading from EF6 with EDMX:

  1. Use the command line tool or the VS Extension to generated DB Context rules from an EDMX file.
  2. Reference EntityFrameworkRuler.Design from the EF Core project.
  3. Run the ef dbcontext scaffold command and the design-time service will do the rest.

Initializing DB Context Rules without an EDMX:

  1. Reference EntityFrameworkRuler.Design from the EF Core project.
  2. Run the ef dbcontext scaffold command and a complete rule file will be generated based on the reverse engineered model. The rules can then be modified, and changes applied by re-running the scaffold command.

DB Context Customization and Ongoing DB Maintenance

  1. Edit the rules json by hand, or with the VS Extension installed, right click on the rules file and go to Edit DB Context Rules.
  2. Apply the customizations (see below).

Applying Model Customizations:

  1. Reference NuGet package EntityFrameworkRuler.Design from the EF Core project. This is a design-time reference, meaning it will not appear in the project build output, but will interact with EF Core's reverse engineer process.
  2. Run the ef dbcontext scaffold command and the design-time service will apply all changes as per the json rule file. The rule file itself will also sync up with the reverse engineered model.

Adding or Removing Tables From the Model:

By default, a rule file generated from EDMX limits tables and columns to just what was in the EDMX. That way, an identical model can be generated.

If it's time to add a table or column to the model, adjust the IncludeUnknownTables or IncludeUnknownColumns flags at the relevant level.

If the database schema contains a lot of tables that you don't want to generate entities for, then enabling IncludeUnknownTables is not a good idea. Instead, manually create the table entry in the rule file (using the Editor) and set IncludeUnknownColumns to true. On the next scaffold, the new entity will be generated fully.

You can remove entities from the model by marking the corresponding table (or column) as Not Mapped.


Entity Configuration Splitting:

The ef dbcontext scaffold command does not natively support splitting entity type configurations into separate files. Instead, all type configurations are stored in the same file as the context.

With EF7, EntityFrameworkRuler.Design can split configurations for you.

Just enable "SplitEntityTypeConfigurations" in the rule file (at the root level).


Installation of the Command Line Tool:

> dotnet tool install --global EntityFrameworkRuler --version <the latest version>

See the NuGet page for details.


Command Line Tool Usage:

To generate rules from an EDMX, run the following:

> efruler -g <edmxFilePath> <efCoreProjectBasePath>

If both paths are the same, i.e. the EDMX is in the EF Core project folder, it is acceptable to run:

> efruler -g <projectFolderWithEdmx>

DB context rules will be extracted from the EDMX and saved in the EF Core project folder.

To Apply rules to an already generated EF Core model:

It is strongly recommended to just run ef dbcontext scaffold with the EntityFrameworkRuler.Design library referenced in order to apply customizations. However, if this is not an option, the following command can apply renaming and type mapping to existing entities (using Roslyn). For very large projects, this can take a minute.

> efruler -a <efCoreProjectBasePath>

API Usage

While the command line tool, EntityFrameworkRuler.Design package, and VS Extension are intended to provide all the features necessary to customize the reverse engineered model, without writing any code, the API is available and fully extensible if you need to tailor the process further.

Reference NuGet package EntityFrameworkRuler.Common

To override default services:
serviceCollection
   .AddRuler()
   .AddSingleton<IRuleSerializer, MyBinaryRuleSerializer>()
   .AddTransient<IRulerNamingService, MyCustomNamingService>()
   .AddTransient<IEdmxParser, MyEdmxParser>()    
To generate rules from an EDMX:
var generator = new RuleGenerator(); // or use injected IRuleGenerator instance
var response = generator.GenerateRules(edmxPath);
if (response.Success)
    await generator.SaveRules(response.Rules.First(), projectBasePath);
Apply rules using Roslyn to a project with rules file in the same path:
var applicator = new RuleApplicator(); // or use injected IRuleApplicator instance
var response = await applicator.ApplyRulesInProjectPath(projectBasePath);
Customize rule file name:
var generator = new RuleGenerator();
var response = generator.GenerateRules(edmxPath);
if (response.Success)
    await generator.SaveRules(projectBasePath, dbContextRulesFile: "DbContextRules.json", response.Rules.First());
Handle log activity:
var applicator = new RuleApplicator();
applicator.Log += (sender, message) => Console.WriteLine(message);
var response = await applicator.ApplyRulesInProjectPath(projectBasePath);

This project is under development! Check back often, and leave comments here.

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last updated
1.3.48 127 9/28/2024
1.3.46 145 8/27/2024
1.3.46-alpha.0.1 43 8/27/2024
1.3.45 151 5/2/2024
1.3.44 101 5/2/2024
1.3.43 87 5/2/2024
1.3.42 75 5/2/2024
1.3.40 220 4/4/2024
1.3.9-alpha.0.1 65 4/4/2024
1.3.8 217 3/21/2024
1.3.7 160 3/21/2024
1.3.6 310 12/19/2023
1.3.5 184 11/29/2023
1.3.4 172 11/18/2023
1.2.40 275 10/26/2023
1.2.39 259 10/25/2023
1.2.38 225 10/24/2023
1.2.37 250 10/23/2023
1.2.36 360 7/17/2023
1.2.34-alpha.0.2 103 7/14/2023
1.2.33 253 7/12/2023
1.2.30 215 6/22/2023
1.2.30-alpha.0.1 84 6/21/2023
1.2.29-alpha.0.1 87 6/20/2023
1.2.28 260 6/20/2023
1.2.27 313 4/18/2023
1.2.26 391 3/23/2023
1.2.25 351 3/16/2023
1.2.22 316 3/7/2023
1.2.21 359 3/6/2023
1.2.21-alpha.0.4 104 3/6/2023
1.2.19 318 2/14/2023
1.2.19-alpha.0.4 104 2/14/2023
1.2.17 373 1/31/2023
1.2.16 367 1/27/2023
1.2.15 350 1/27/2023
1.2.14 361 1/26/2023
1.2.13 374 1/25/2023
1.2.10 352 1/25/2023
1.2.9 325 1/25/2023
1.2.8 338 1/25/2023
1.2.7 424 1/24/2023
1.2.6 388 1/24/2023
1.2.5 360 1/24/2023
1.2.4 345 1/18/2023
1.2.3 354 1/17/2023
1.2.3-alpha.0.1 143 1/9/2023
1.2.2 399 1/9/2023
1.2.1-alpha.0.2 166 1/6/2023
1.2.0 385 1/5/2023
1.1.8-alpha.0.16.4 136 1/5/2023
1.1.8-alpha.0.16.2 188 1/5/2023
1.1.8-alpha.0.16.1 195 1/5/2023
1.1.8-alpha.0.16 157 1/5/2023
1.1.8-alpha.0.15 187 1/4/2023
1.1.7 440 12/14/2022
1.1.6-alpha.0.5 118 12/14/2022
1.1.6-alpha.0.4 119 12/13/2022
1.1.6-alpha.0.2 107 12/13/2022
1.1.6-alpha.0.1 103 12/13/2022
1.1.5 407 12/9/2022
1.1.3 385 12/8/2022
1.1.3-alpha.0.2 93 12/8/2022
1.1.3-alpha.0.1 103 12/8/2022
1.1.2 357 12/8/2022
1.1.1 362 12/7/2022
1.1.0 385 12/6/2022
1.0.29-alpha.0.50 110 12/6/2022
1.0.29-alpha.0.48 112 12/6/2022
1.0.29-alpha.0.22 115 11/30/2022
1.0.28 437 11/18/2022
1.0.27 466 11/18/2022
1.0.26 421 11/18/2022
1.0.25 439 11/18/2022
1.0.22 423 11/17/2022
1.0.21 412 11/17/2022
1.0.20 372 11/16/2022
1.0.20-alpha.0.2 104 11/16/2022
1.0.20-alpha.0.1 107 11/16/2022
1.0.19 425 11/16/2022
1.0.18 413 11/16/2022
1.0.17-alpha.0.2 106 11/16/2022
1.0.17-alpha.0.1 117 11/15/2022
1.0.16 401 11/15/2022
1.0.16-alpha.0.2 102 11/15/2022
1.0.14-alpha.0.17 99 11/15/2022