Apps72.Dev.Data.Generator.Tools 4.3.0.1

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 4.3.0.1
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 Entities.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.
Go to https://apps72.com for the documentation.

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

Example:

  • This command gets all tables/columns and generates an Entities.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.
Go to https://apps72.com for the documentation.

Release Notes

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

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
4.3.0.1 195 10/8/2020
4.3.0 63 10/8/2020
4.2.4 82 10/7/2020
4.2.3 70 10/7/2020
4.1.2 197 9/16/2020
4.0.3.1 725 2/6/2020
4.0.3 172 2/6/2020
3.3.0 552 8/26/2019
3.2.0 287 7/30/2019
3.1.0 203 7/29/2019
2.7.5 433 8/9/2018
2.6.0 496 6/14/2018