Codelightly.CLI 1.0.0

.NET 8.0 This package targets .NET 8.0. The package is compatible with this framework or higher. 
dotnet tool install --global Codelightly.CLI --version 1.0.0
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 Codelightly.CLI --version 1.0.0
This package contains a .NET tool you can call from the shell/command line. 
#tool dotnet:?package=Codelightly.CLI&version=1.0.0
                    


                    

                
nuke :add-package Codelightly.CLI --version 1.0.0

Codelightly CLI - Data Access Layer Generator

Command-line tool for generating data access layers (DAL) from database schemas. Supports SQL Server and Oracle databases with customizable C# code generation.

Installation

dotnet tool install -g Codelightly.CLI

Quick Start

# View help
codelightly --help

# Generate DAL from SQL Server
codelightly generate \
  --connection "Server=localhost;Database=MyDB;User Id=sa;Password=password" \
  --type SqlServer \
  --output ./GeneratedDAL \
  --project MyProject

# Generate DAL from Oracle
codelightly generate \
  --connection "Data Source=localhost:1521/ORCL;User Id=system;Password=password" \
  --type Oracle \
  --output ./GeneratedDAL \
  --project MyProject

Commands

generate

Generate data access layer code from a database schema.

Options:

  • --connection - Database connection string (required)
  • --type - Database type: SqlServer or Oracle (required)
  • --output - Output directory for generated files (required)
  • --project - Project name for generated code (required)
  • --table - Specific table to generate (optional, default: all)
  • --verbose - Enable verbose output (optional)

Examples:

# Generate for all tables
codelightly generate \
  --connection "Server=localhost;Database=MyDB;User Id=sa;Password=password" \
  --type SqlServer \
  --output ./GeneratedDAL \
  --project MyProject

# Generate for specific table
codelightly generate \
  --connection "Server=localhost;Database=MyDB;User Id=sa;Password=password" \
  --type SqlServer \
  --output ./GeneratedDAL \
  --project MyProject \
  --table Users

# With verbose output
codelightly generate \
  --connection "Server=localhost;Database=MyDB;User Id=sa;Password=password" \
  --type SqlServer \
  --output ./GeneratedDAL \
  --project MyProject \
  --verbose

Supported Databases

  • SQL Server - SQL Server 2012 and later
  • Oracle - Oracle 11g and later

Generated Output

The tool generates:

  • Model classes for each table
  • Repository classes for data access
  • Database helper utilities
  • Query builders

Documentation

License

MIT License - See LICENSE file for details

Support

For issues and questions, visit the GitHub repository

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  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.  net9.0 was computed.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.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.0.0 303 11/13/2025