CHC.EF.Reverse.Poco - Effortless Entity Framework Core Model Generation

This .NET Global Tool streamlines the creation of Entity Framework Core models from your existing database schema. By intelligently analyzing your database structure, it automatically generates clean, efficient C# code for your data access layer.

Why Choose CHC.EF.Reverse.Poco?

• Simplicity: A single command generates all the necessary code: POCO classes, DbContext, and configurations.
• Efficiency: Eliminate tedious manual coding and focus on building your application logic.
• Flexibility: Supports SQL Server, MySQL, and PostgreSQL with customizable settings.
• Maintainability: Keep your models in sync with your database schema with ease.

Installation

Ensure you have the .NET 8 SDK installed. Then, install the tool globally using:

dotnet tool install --global CHC.EF.Reverse.Poco

Usage

Generate your models with a single command:

efrev --connection "your_connection_string" --provider "your_provider_name" --output "your_output_directory"

Options:

• --connection: Your database connection string.
• --provider: The database provider (SqlServer/MySql/PostgreSql).
• --output: The directory for generated code.
• --pluralize: Pluralize table names (default: true).
• --data-annotations: Use data annotations (default: true).

Example:

efrev --connection "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;" --provider SqlServer --output "C:\MyProject\Models"

Advanced Configuration

Fine-tune the code generation process using an appsettings.json file:

{ "CodeGenerator": { "ConnectionString": "your_connection_string", "ProviderName": "your_provider_name", "Namespace": "your_namespace", "OutputDirectory": "your_output_directory", "IsPluralize": true, "UseDataAnnotations": true } }

Key Features

• Relationship Mapping: Accurately handles one-to-one, one-to-many, and many-to-many relationships.
• Data Annotations: Optionally decorate your models with data annotations for validation and metadata.
• Efficiently manages database connections for optimal performance.