Forem: Amina Elsheikh

ABP vs RepoGen

Amina Elsheikh — Sun, 06 Jul 2025 17:42:23 +0000

I Asked ChatGPT: What’s the Difference Between `DEFC.Util.RepoGen` and the ABP Framework for .NET?

"I’m building a .NET project and found two interesting tools: DEFC.Util.RepoGen and the ABP Framework. They both promise productivity, but they seem to solve very different problems. So, I did what any curious dev would do — I asked ChatGPT."

Here’s what I learned, and it helped me make a clear decision. If you're wondering the same, this might save you some research time. 🧠

⚔️ The TL;DR

Feature / Aspect	DEFC.Util.RepoGen	ABP Framework
What is it?	A CLI tool for auto-generating Repositories, Unit of Work, and CRUD services	A full-stack, modular, enterprise app framework
Ideal For	Projects with stored procedures or existing DBs	Building domain-driven, scalable .NET apps from scratch
Architecture Style	Clean Architecture (with optional folder models)	Domain-Driven Design (DDD), Layered, Modular
Stored Procedure Support	✅ First-class via CLI mapping	⚠️ Manual/indirect support
CRUD Table Support	✅ Full CRUD generation (Repo, Service, Controller)	✅ Scaffolded via framework conventions
UI Support	❌ None (backend only)	✅ Angular/Blazor UI generation
Learning Curve	🟢 Simple and lightweight	🔴 Medium to high
Out-of-the-box Features	Just scaffolding — nothing more	Auth, multi-tenancy, localization, modularity, etc.

🧰 DEFC.Util.RepoGen in a Nutshell

It’s a CLI utility that generates boilerplate code for:

* Repositories
* Unit of Work
* CRUD Services
* Optional Controller classes

It works for both:

* **Stored procedures** (via mapping commands)
* **Tables** (via `crud` command)

You configure your setup via a RepoGen.json file, run a few CLI commands, and it scaffolds clean, layered architecture following your chosen structure.

💡 If your DB is already built and you’re tired of writing repetitive Repository/Service code — this tool is a huge time-saver.

🏗️ ABP Framework: The Full Package

ABP is a full-stack, open-source framework for building modular and scalable .NET applications.

Out-of-the-box, it includes:

- Authentication & Authorization
- Multi-tenancy
- Localization
- UI frameworks (Angular, Blazor)
- Domain services

It’s built around Domain-Driven Design (DDD) principles and is ideal for greenfield projects that need full enterprise features.

💡 If you’re planning a long-living SaaS platform — ABP might be all you need.

🧠 My Takeaway After ChatGPT's Explanation

If you’re working with an existing database, especially one full of stored procedures or defined table structures, and just want clean, testable code fast — DEFC.Util.RepoGen is fantastic.

If you’re building a new, enterprise-grade app with multi-tenancy, auth, localization, modular UIs — ABP Framework is your friend (but expect a learning curve).

💬 What Did I Choose?

I ended up using RepoGen for a project where the database already existed and was full of stored procedures. It let me map SPs to repos in seconds, and I stayed in full control of the architecture.

If I start a brand new SaaS product later on, especially one that needs multi-tenancy and built-in auth, ABP will be at the top of my list.

📚 More About RepoGen

🛠️ How I Reduced My .NET Repository Development Time by more than 50% with RepoGen

Amina Elsheikh — Tue, 24 Jun 2025 12:59:16 +0000

As developers, we know the pain of writing repetitive code for repository classes — especially when working with stored procedures in .NET. Creating repositories manually can be time-consuming and error-prone, which leads to wasted development time and maintenance headaches.

That's when I found RepoGen. It’s a tool that automates the entire process of repository generation, and in this post, I’ll explain how I reduced my repository development time by 50% and kept my codebase clean and consistent.

🏁 The Problem: Repository Generation Without Automation

When starting a new .NET project, I often had to create repositories manually, mapping each stored procedure to a repository method. Every time the stored procedure changed, or new ones were added, I had to go back and update multiple repository classes. It felt like I was repeating the same process over and over again, which wasn’t productive.

The Challenges I Faced:

Repetitive Work: Writing similar methods for every stored procedure.
Error-Prone: Manually mapping SPs often led to missing or incorrect mappings.
Hard to Maintain: With multiple repositories, any changes in structure required refactoring multiple files.

⚡ The Solution: RepoGen

RepoGen is a NuGet CLI tool that automates repository and unit of work creation based on your stored procedures. Instead of writing the same code over and over again, RepoGen generates the repository classes for you. Here the key features:

✅ Automatic Repository Generation – Generates repository classes mapped to SQL Server stored procedures.
✅ Unit of Work Integration – Creates a UnitOfWork class to manage transactions across repositories.
✅ Stored Procedure Mapping – Automates method creation inside repositories that correspond to stored procedures.
✅ CRUD Generator – Generates full CRUD (Create, Read, Update, Delete) logic and models for SQL tables.
✅ Clean Architecture Support – Supports multiple folder structures: Clean, Layered, Hexagonal, or Custom.
✅ Batch Command Execution – Run multiple operations from a JSON batch script.
✅ Dynamic DTO & Model Generation – Generates Data Transfer Objects and domain models from stored procedures or tables.
✅ Endpoint Creation – Auto-generates RESTful controller endpoints (e.g., POST, GET, PUT, DELETE) alongside SP and CRUD mappings.
✅ Offline & Secure – Operates fully offline with no external calls or telemetry.

📚 Documentation

Full guides, step-by-step examples, and command references are available in the 📘 Wiki

📦 Try It Yourself

RepoGen is available now as a NuGet package. If you're working on a .NET project and want to save time while keeping your code clean, give RepoGen a try!

You can find RepoGen on NuGet.

You can find RepoGen sample on GitHub.

📎 Related Packages

📚 More About RepoGen

Automate Repository Generation in .NET with RepoGen

🙏 Thank you for supporting the development of DEFC.Util.RepoGen. Let’s build clean, maintainable .NET applications together!

🛠️ Automate Repository Generation in .NET with RepoGen

Amina Elsheikh — Tue, 24 Jun 2025 12:56:07 +0000

DEFC.Util.RepoGen

If you’ve ever built a .NET application that uses stored procedures, you’ve probably written a lot of repetitive repository code. While clean architecture and the repository pattern are great for maintainability, they come with a cost — boilerplate.

That’s why I built RepoGen — a NuGet CLI tool that helps .NET developers automatically generate repository classes, structure folders, and map stored procedures with just a few commands.

🧩 What is RepoGen?

DEFC.Util.RepoGen is a .NET CLI and NuGet tool that automates the implementation of the Repository
and Unit of Work patterns using SQL Server stored procedures. It simplifies the generation of clean,
scalable, and maintainable architecture in .NET applications, while promoting strong separation of concerns.

🚧 Beta Version Notice
🔬 This is a Beta Release
DEFC.Util.RepoGen is currently in beta and under active testing. While it is functional and ready for
practical use, we are still refining and improving the tool based on user feedback.

We invite developers and teams to test the tool in real-world scenarios and help us identify bugs, edge cases, or areas for improvement.
Your feedback is valuable and will directly contribute to shaping the final stable release.

🛠️ Key Features

✅ Automatic Repository Generation – Generates repository classes mapped to SQL Server stored procedures.
✅ Unit of Work Integration – Creates a UnitOfWork class to manage transactions across repositories.
✅ Stored Procedure Mapping – Automates method creation inside repositories that correspond to stored procedures.
✅ CRUD Generator – Generates full CRUD (Create, Read, Update, Delete) logic and models for SQL tables.
✅ Clean Architecture Support – Supports multiple folder structures: Clean, Layered, Hexagonal, or Custom.
✅ Batch Command Execution – Run multiple operations from a JSON batch script.
✅ Dynamic DTO & Model Generation – Generates Data Transfer Objects and domain models from stored procedures or tables.
✅ Endpoint Creation – Auto-generates RESTful controller endpoints (e.g., POST, GET, PUT, DELETE) alongside SP and CRUD mappings.
✅ Offline & Secure – Operates fully offline with no external calls or telemetry.

🛠 Prerequisites

Install required EF Core dependencies:

dotnet add package Microsoft.EntityFrameworkCore
dotnet add package Microsoft.EntityFrameworkCore.SqlServer
dotnet add package Microsoft.Data.SqlClient

📦 Installation

Install the NuGet package:

dotnet new tool-manifest

dotnet tool install --local DEFC.Util.RepoGen --version 1.0.0-beta

🚀 Quick Start

Initialize:

dotnet tool run RepoGen initial

dotnet tool run RepoGen initial

Configure RepoGen.json:

{
  "Config": {
    "DBConfig": {
      "SchemaID": "1",
      "DBContextName": "YOUR_DBCONTEXTNAME_HERE",
      "ConnectionString": "Server=SERVER_NAME;Database=DATABASE_NAME;User Id=USER_NAME;Password=PASSWORD;TrustServerCertificate=True"
    },
    "AppConfig": {
      "Namespace": "YOUR_NAMESPACE_HERE",
      "FoldersStructureModel": "MODEL_1",
      "LoggerCode": "101",
      "Suffixes": {
        "Model": "Models", // Suffix for domain or entity classes
        "DTO": "Dtos" // Suffix for data transfer objects 

      }
    }
  }
}

Generate Folder Structure:

dotnet tool run RepoGen structure set

Test DB Connection:

dotnet tool run RepoGen test db-connection

dotnet tool run RepoGen  structure test

Generate CRUD for a Table:

dotnet tool run RepoGen crud --tbl <YourTableName> --service <YourServiceName> --controller <YourControllerName>

dotnet tool run RepoGen crud --tbl <YourTableName> --service <YourServiceName>

Stored Procedure Mapping

1- Map a stored procedure to a repository:

dotnet tool run RepoGen map --sp <YourStoredProcedureName> --repo <YourRepoName> --controller <ControllerName> --endpoint <EndpointName> --<Method>

dotnet tool run RepoGen map --sp <YourStoredProcedureName> --repo <YourRepoName>

2- Remap a stored procedure to a repository with controller endpoint:

dotnet tool run RepoGen re-map --sp <YourStoredProcedureName> --repo <YourRepoName> --controller <ControllerName> --endpoint <EndpointName> --<Method>

3- Remove a mapped stored procedure:

dotnet tool run RepoGen remove --sp <YourStoredProcedureName> --repo <YourRepoName>

📁 Architecture Support

🧱 MODEL_1: Clean Architecture (default)
🧱 MODEL_2: Layered Architecture
🧱 MODEL_3: Hexagonal (Ports & Adapters)
🧱 MODEL_CUSTOM: Fully configurable layout via custom_model.json

📚 Documentation

Full guides, step-by-step examples, and command references are available in the 📘 Wiki

📦 Try It Yourself

RepoGen is available now as a NuGet package. If you're working on a .NET project and want to save time while keeping your code clean, give RepoGen a try!

You can find RepoGen on NuGet.

You can find RepoGen sample on GitHub.

📎 Related Packages

📄 License

Licensed under the Elastic License 2.0.
See full license details here.

🐞 Issues & Feedback

Found a bug or want to contribute?
📬 Open an issue

📚 More About RepoGen

How I Reduced My .NET Repository Development Time by more than 50% with RepoGen

🙏 Thank you for supporting the development of DEFC.Util.RepoGen. Let’s build clean, maintainable .NET applications together!

Data Generator Nuget Package

Amina Elsheikh — Mon, 27 Feb 2023 12:00:13 +0000

Objective

This is a cross platform NET Standard 2.0 generator library containing a bunch of generating codes that I needed while developing apps. I hope it will save your development time.

About

This library is one of DEFC utilities packages that contains several types of data generating, to help the developers minify their codes in easy way with no time. Through this package can :

Generate GUID.
Generate Random Symbol.
Generate Unique Code and compare it to a list.
Generate Random String with specific length and choose if it is lowercase or uppercase or both.
Generate Random Number between min and max.
Generate any Random Code.

Example

Install-Package DEFC.Util.Generator --version 1.0.0

using DEFC.Util;

public static string GeneratePassword()
        {
            StringBuilder builder = new StringBuilder();
            builder.Append(Generator.RandomString(2, true));//2 lower case random letters
            builder.Append(Generator.RandomString(3, false));//3 uppper case random letters
            builder.Append(Generator.RandomSymbol());//random symbol
            builder.Append(Generator.RandomNumber(1000, 9999));//random number between 1000 and 9999

            return builder.ToString();
        }
        public static string GenerateUser(List<string> ListToCheck)
        {
            char[] CharacterSet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890".ToCharArray();
            //Generate user with 20 characters length from a set of character and check if it is already exists in a list of users    

            return Generator.UniqueCode(CharacterSet, 20, ListToCheck);   
        }         
        public static string GenerateClientID()
        {
            char[] CharacterSet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ01234567890".ToCharArray();

            StringBuilder builder = new StringBuilder();
            builder.Append(Generator.RandomCode(CharacterSet,8));//8 random characters
            builder.Append("-");
            builder.Append(Generator.RandomCode(CharacterSet, 4));//4 random characters
            builder.Append("-");
            builder.Append(Generator.RandomCode(CharacterSet, 12));//12 random characters
            return builder.ToString();
        }

Data Validation Nuget Package

Amina Elsheikh — Mon, 27 Feb 2023 11:49:58 +0000

Objective

This is a cross platform NET Standard 2.0 validation library containing a bunch of validation code that we have to rewrite every time we develop apps. Due to the time we have to spend every day in validating data. This library was developed to help in saving our development time.

About

This library is one of DEFC utilities packages that contains several types of data validation methods, to help the developers minify their codes in easy way with no time. Through this package can :

Check if a value is (Alphanumeric, Alpha, GUID, Base64, NullOrEmptyOrWhiteSpace, Email,URL,DateTime, Number, Byte, Short, Integer, Long, Decimal, Double, Float, IPv4, IPv6, IP, MACAddress, LatitudeLongitude )
Check if a value is between tow values, check if a value is between tow values or equal one of them, check if a value is equal to another value, check if value is greater than or equal another value and check if value is less than or equal another value.
Match password and confirm password.
Check if password is strong with at least one uppercase, one lowercase, one digit and one of the custom symbols with specific password length by sets the password rules. this library is available on nuget.

Install-Package DEFC.Util.DataValidation -Version 1.0.0

Example

Console application with full example available at the GitHub repository.

using DEFC.Util.DataValidation;
using System.Text.RegularExpressions;


C#
 public static void Validator()
        {           
            //Sample of data type validator
            bool IsValidAlphanumeric= DataType.IsAlphanumeric("Foo1234");
            bool IsValidGUID = DataType.IsGUID("am I a GUID");
            bool IsValidIPv4 = DataType.IsIPv4("127.0.0.1");
            bool IsValidURL = DataType.IsURL("https://www.nuget.org");
            //Sample of math validator
            bool IsValidNegative = Math.IsNegative(-1);
            bool IsValidEven = Math.IsEven(9);
            //Sample of comparison validator
            bool IsBetween = Comparison.IsBetween(4,2,10);
            bool IsLessThanOrEqual = Comparison.IsLessThanOrEqual(12,3);
            //Sample of SQL Injection validator
            bool HasSQLInjection = SQLInjection.IsExists("' or 1=1");
            //Sample of Regular Expression validator
            bool IsValidExpression = RegularExpression.IsMatch("Foo1234",new Regex("[a-zA-Z0-9]*$"));
            //Sample of Password validator
            bool Isvalid = Password.ValidatRules(new PasswordRules() 
                                                {
                                                 Password="Foo@123",
                                                 HasUpper=true,
                                                 HasLower=true,
                                                 HasDigit=true,
                                                 HasLength=true,
                                                 passwordMinLength=6,
                                                 HasSymbols=true,
                                                 symbols="@,&"
                                                });
        }

C# Why to Validate Data?

Amina Elsheikh — Mon, 19 Sep 2022 11:28:39 +0000

Introduction

Having accurate, high quality source data means that we will generate data that is clean, helpful, consistent, and accurate aiming to avoid data loss and errors during the using of the data, migrating and merging data.

Definition

Data Validation is the process of making sure that the data source is accurate before collecting, using, importing, analyzing, or preparing data.

Importance of validation

Reducing Data Loss.
Producing accurate Data.
Avoiding Errors.
Making decision based on wrong data.

Some Types of Validations

Data Type Validation Validating emails, numeric, IPs, URL an so on.
Null-ability Validation Checking data if null or not selected.
Range Validation Validate whether input data falls within a predefined range.
Consistency Validation Confirms the data has been entered in a logically consistent way. For example, date is not in the future or password is follow the predefined rules.
Uniqueness Validation Ensures that an item is not entered multiple times into a database.
Length Validation Ensures that the appropriate number of characters are entered into the field.

Issue

Although data Validation is a critical step in any data workflow, but also it may slow down the developing time and my be boring for some of us because of having to redo it in every application.

We can save our developing time and make it less boring by using one the data validation libraries a available online to be installed and used.

In the fallowing example I will use DEFC.Util.DataValidation library as an example of those libraries. this library is available on nuget.

Install-Package DEFC.Util.DataValidation -Version 1.0.0

Example

Console application with full example available at the GitHub repository.

using DEFC.Util.DataValidation;
using System.Text.RegularExpressions;


C#
 public static void Validator()
        {           
            //Sample of data type validator
            bool IsValidAlphanumeric= DataType.IsAlphanumeric("Foo1234");
            bool IsValidGUID = DataType.IsGUID("am I a GUID");
            bool IsValidIPv4 = DataType.IsIPv4("127.0.0.1");
            bool IsValidURL = DataType.IsURL("https://www.nuget.org");
            //Sample of math validator
            bool IsValidNegative = Math.IsNegative(-1);
            bool IsValidEven = Math.IsEven(9);
            //Sample of comparison validator
            bool IsBetween = Comparison.IsBetween(4,2,10);
            bool IsLessThanOrEqual = Comparison.IsLessThanOrEqual(12,3);
            //Sample of SQL Injection validator
            bool HasSQLInjection = SQLInjection.IsExists("' or 1=1");
            //Sample of Regular Expression validator
            bool IsValidExpression = RegularExpression.IsMatch("Foo1234",new Regex("[a-zA-Z0-9]*$"));
            //Sample of Password validator
            bool Isvalid = Password.ValidatRules(new PasswordRules() 
                                                {
                                                 Password="Foo@123",
                                                 HasUpper=true,
                                                 HasLower=true,
                                                 HasDigit=true,
                                                 HasLength=true,
                                                 passwordMinLength=6,
                                                 HasSymbols=true,
                                                 symbols="@,&"
                                                });
        }

Forem: Amina Elsheikh

ABP vs RepoGen

I Asked ChatGPT: What’s the Difference Between DEFC.Util.RepoGen and the ABP Framework for .NET?

⚔️ The TL;DR

🧰 DEFC.Util.RepoGen in a Nutshell

🏗️ ABP Framework: The Full Package

🧠 My Takeaway After ChatGPT's Explanation

💬 What Did I Choose?

📚 More About RepoGen

🛠️ How I Reduced My .NET Repository Development Time by more than 50% with RepoGen

🏁 The Problem: Repository Generation Without Automation

⚡ The Solution: RepoGen

📚 Documentation

📦 Try It Yourself

📎 Related Packages

📚 More About RepoGen

🛠️ Automate Repository Generation in .NET with RepoGen

DEFC.Util.RepoGen

🧩 What is RepoGen?

🛠️ Key Features

🛠 Prerequisites

📦 Installation

🚀 Quick Start

📁 Architecture Support

📚 Documentation

📦 Try It Yourself

📎 Related Packages

📄 License

🐞 Issues & Feedback

📚 More About RepoGen

Data Generator Nuget Package

Objective

About

Example

Data Validation Nuget Package

Objective

About

Example

C# Why to Validate Data?

Introduction

Definition

Importance of validation

Some Types of Validations

Issue

Example

I Asked ChatGPT: What’s the Difference Between `DEFC.Util.RepoGen` and the ABP Framework for .NET?