Apps72.Dev.Data.Generator.Tools 2.7.5

DbCmd is a command line tools to generate entities (class) from existing databases (SQL Server, Oracle or SQLite). This tool is also an assembly usable by your core project to retrieve tables and columns, and to generate C# or TypeScript code.

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

Update (if already installer) dotnet tool update -g Apps72.Dev.Data.Generator.Tools

Use Help to display all commands and options. DbCmd --Help

Example: This command gets all tables/columns and generates an Output.cs file with all equivalent classes.

C:\> DbCmd GenerateEntities -cs="Server=MyServer;Database=Scott;" --provider=SqlServer

SqlDatabase Command Line Tools
Project on https://github.com/Apps72/Dev.Data
  Entities generating...
  4 entities generated in Entities.cs. 1.22 seconds.

namespace Entities
{
    using System;

    /// <summary />
    public partial class DEPT
    {
        /// <summary />
        public virtual int DEPTNO { get; set; }
        /// <summary />
        public virtual string DNAME { get; set; }
        /// <summary />
        public virtual string LOC { get; set; }
    }
    ...
}