How nouraldeenkanaan/3tier-crud-codegenerator works
This is a WinForms utility that discovers SQL Server databases, collects a table name and column metadata, and generates BLL and DAL C# source files on the desktop. The graph follows the evidenced login-to-schema-entry-to-generation workflow and retains database discovery, configuration, metadata modeling, template generation, and formatting as distinct responsibilities. README capabilities such as async generation, DTOs, CRUD templates, and validation are included; only relationships shown in excerpts or documented in the README are connected.
Main entry points: frmMain.cs Table inputs · clsGenerateCRUD.cs Generation orchestrator · frmLogin.cs Database login · clsLoginInformations.cs Database discovery
Components 15
Desktop interface
- App launcher
CRUD_OperationsGenerator/Program.cs - Database login
CRUD_OperationsGenerator/frmLogin.cs - Table inputs
CRUD_OperationsGenerator/frmMain.cs
Generation business layer
- Generation state
CRUD_OperationsGeneratorBusiness/clsGlobal.cs - Column metadata
CRUD_OperationsGeneratorBusiness/clsColumn.cs - Login facade
CRUD_OperationsGeneratorBusiness/clsLoginInfo.cs - Generation orchestrator
CRUD_OperationsGeneratorBusiness/clsGenerateCRUD.cs - DAL templates
CRUD_OperationsGeneratorBusiness/clsGenerateCRUD.cs - BLL templates
CRUD_OperationsGeneratorBusiness/clsGenerateCRUD.cs - SQL formatting helpers
CRUD_OperationsGeneratorBusiness/clsUtility.cs
Database discovery
- App configuration
CRUD_OperationsGeneratorData/clsAppConfigurations.cs - Database discovery
CRUD_OperationsGeneratorData/clsLoginInformations.cs
Other components
- Operator
- SQL Server
- Generated C# files
Connections 18
- Operator → App launcher: starts app
CRUD_OperationsGenerator/Program.cs - App launcher → Database login: opens
CRUD_OperationsGenerator/Program.cs - Operator → Database login: selects database
CRUD_OperationsGenerator/frmLogin.cs - Database login → Login facade: requests databases
CRUD_OperationsGenerator/frmLogin.cs - Login facade → Database discovery: delegates to
CRUD_OperationsGeneratorBusiness/clsLoginInfo.cs - Database discovery → App configuration: uses connection string
CRUD_OperationsGeneratorData/clsLoginInformations.cs - Database discovery → SQL Server: queries databases
CRUD_OperationsGeneratorData/clsLoginInformations.cs - Database login → Generation state: stores database name
CRUD_OperationsGenerator/frmLogin.cs - Operator → Table inputs: enters schema
CRUD_OperationsGenerator/frmMain.cs - Table inputs → Generation state: sets names and columns
CRUD_OperationsGenerator/frmMain.cs - Table inputs → Column metadata: creates metadata
CRUD_OperationsGenerator/frmMain.cs - Table inputs → Generation orchestrator: requests generation
CRUD_OperationsGenerator/frmMain.cs - Generation orchestrator → BLL templates: builds BLL source
CRUD_OperationsGeneratorBusiness/clsGenerateCRUD.cs - Generation orchestrator → DAL templates: builds DAL source
CRUD_OperationsGeneratorBusiness/clsGenerateCRUD.cs - DAL templates → SQL formatting helpers: uses SQL helpers
CRUD_OperationsGeneratorBusiness/clsGenerateCRUD.cs - BLL templates → DAL templates: emits DAL calls
README.md - Generation orchestrator → Generated C# files: writes files
CRUD_OperationsGeneratorBusiness/clsGenerateCRUD.cs - Operator → Table inputs: validates inputs
CRUD_OperationsGenerator/frmMain.cs