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.

There is a newer version of this package available.
See the version list below for details.
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
4.3.0.1 186 10/8/2020
4.3.0 61 10/8/2020
4.2.4 80 10/7/2020
4.2.3 68 10/7/2020
4.1.2 195 9/16/2020
4.0.3.1 723 2/6/2020
4.0.3 170 2/6/2020
3.3.0 550 8/26/2019
3.2.0 285 7/30/2019
3.1.0 199 7/29/2019
2.7.5 430 8/9/2018
2.6.0 494 6/14/2018
Show less