Apps72.Dev.Data.Generator.Tools 3.2.0

DbCmd is a command line tools to generate entities (class) from existing databases (SQL Server, Oracle or SQLite), to merge script files into a single file or to execute scripts. This tool is also an assembly usable by your .NET project to retrieve tables and columns, and to generate C# or TypeScript code.

dotnet tool install --global Apps72.Dev.Data.Generator.Tools --version 3.2.0
This package contains a .NET Core Global Tool you can call from the shell/command line.

Installation:
dotnet tool install -g Apps72.Dev.Data.Generator.Tools

Example:

  • This command gets all tables/columns and generates an Output.cs file with all equivalent classes.
    DbCmd GenerateEntities -cs=Server=localhost;Database=Scott; --provider=SqlServer

  • This command merges all sql files, of the current directory, to a new one.
    DbCmd Merge --source=C:\Temp --output=allScripts.sql

  • This command executes all sql files, of the current directory, to this SQL Server.
    DbCmd Run --source=C:\Temp -cs=Server=localhost;Database=Scott;

    With Run command, use --DbConfigAfter and --DbConfigUpdate to set SQL queries to
    select and to update a database field with the name of the last executed script.
    Only next scripts will be read and executed.

More details:
Use DbCmd --Help to display all commands and options.

Installation:
dotnet tool install -g Apps72.Dev.Data.Generator.Tools

Example:

  • This command gets all tables/columns and generates an Output.cs file with all equivalent classes.
    DbCmd GenerateEntities -cs=Server=localhost;Database=Scott; --provider=SqlServer

  • This command merges all sql files, of the current directory, to a new one.
    DbCmd Merge --source=C:\Temp --output=allScripts.sql

  • This command executes all sql files, of the current directory, to this SQL Server.
    DbCmd Run --source=C:\Temp -cs=Server=localhost;Database=Scott;

    With Run command, use --DbConfigAfter and --DbConfigUpdate to set SQL queries to
    select and to update a database field with the name of the last executed script.
    Only next scripts will be read and executed.

More details:
Use DbCmd --Help to display all commands and options.

Release Notes

See https://github.com/Apps72/Dev.Data

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
3.2.0 117 7/30/2019
3.1.0 58 7/29/2019
2.7.5 216 8/9/2018
2.6.0 307 6/14/2018