EntityFrameworkRuler.Editor 1.0.17-alpha.0.2

Entity Framework Ruler - Editor

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

• Class renaming
• Property renaming (including both primitives and navigations)
• Type changing (useful for enum mapping)
• Skipping non-mapped columns.
• Forcing inclusion of simple many-to-many entities into the model.

EF Ruler applies customizations from a rule document stored in the project folder. Rules can be fully generated from an EDMX (from old Entity Framework) 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 couldn't be simpler:

1. The the CLI tool to analyze the EDMX for all customizations and generate the rules.
2. Discard the EDMX (optional of course).
3. Reference EntityFrameworkRuler.Design from the EF Core project and run the ef dbcontext scaffold command.

Done.

Applying the Model Customizations:

There are two options for applying the rules to a DB context model:

1. Simply reference EntityFrameworkRuler.Design from the EF Core project. Proceed with CLI scaffolding (as mentioned above). EntityFrameworkRuler.Design is a Design-Time reference package, meaning EF Core can use it during the scaffolding process to customize the generated model, but the assembly will NOT appear in the project build output. It can't get more automated than this.
2. Use the CLI tool to apply changes to an already generated EF Core model. This approach uses Roslyn to apply code changes. The code analysis is reliable, but for very large models this option can take a minute.

Road Map:

• EF Power Tools built-in support.
• Editor library to manage the rules and edit the EF Core model structure with a UI.

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

Installation of the CLI tool:

There are 2 ways to use the CLI tool:

1. Command line:

   > dotnet tool install --global EntityFrameworkRuler 
   

2. API:

   > dotnet add package EntityFrameworkRuler   
   PM> NuGet\Install-Package EntityFrameworkRuler
   

See the NuGet page for details.

CLI 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>

Structure 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:

> efruler -a <efCoreProjectBasePath>

This assumes that you have executed the scaffolding process to generate the model from the database. For details on reverse engineering, go to: https://learn.microsoft.com/en-us/ef/core/managing-schemas/scaffolding/?tabs=dotnet-core-cli

API Usage

To generate rules from an EDMX, use the following class:

EntityFrameworkRuler.Generator.RuleGenerator

To Apply rules to an EF Core model, use the following class:

EntityFrameworkRuler.Applicator.RuleApplicator

Examples

Generate and save rules:

var generator = new RuleGenerator(edmxPath);  
var rules = generator.TryGenerateRules();  
await generator.TrySaveRules(projectBasePath);

Apply rules already in project path:

var applicator = new RuleApplicator(projectBasePath);  
var response = await applicator.ApplyRulesInProjectPath();

More control over which rules are applied:

var applicator = new RuleApplicator(projectBasePath);  
var loadResponse = await applicator.LoadRulesInProjectPath();  
var navRules = loadResponse.Rules.OfType<NavigationNamingRules>().First();
var applyResponse = await applicator.ApplyRules(enumRules);

Customize rule file names:

var generator = new RuleGenerator(edmxPath);  
var rules = generator.TryGenerateRules();  
await generator.TrySaveRules(projectBasePath,  
    new RuleFileNameOptions() {  
        PrimitiveRulesFile = null, // null will skip this file
        NavigationRulesFile = "NavRules.json" 
  }  
);

Handle log activity:

var applicator = new RuleApplicator(projectBasePath);  
applicator.OnLog += (sender, message) => Console.WriteLine(message);
var response = await applicator.ApplyRulesInProjectPath();