Content
With the help of this program you can easily generate C# classes from database tables.
You can select which tables are to be used. In addition, you can use a separate alias for each table or column name.
The program is the little brother of the program MsSqlToolBelt.
Note: This programme only supports MS SQL databases.
The programme can be used in two ways:
- desktop application
- via console (cmd, powershell, etc.)
The following parameters are provided by the program:
| Parameter | Description | Example | Program |
|---|---|---|---|
-s / --server |
The name / path of the MS SQL Server - Mandatory for CLI / Optional for WPF App. | -s (localdb)\MsSqlLocalDb |
Both |
-d / --database |
The name of the desired database - Mandatory for CLI / Optional for WPF App. | -d AdventureWorks |
Both |
-o / --output |
The path of the output directory wich should hold the genereated classes - Mandatory. | D:\SomeDir |
Only CLI |
-n / --namespace |
The desired namespace which should be used - Mandatory. |
-n MyNameSpace |
Only CLI |
-m / --modifier |
The desired modifier which should be used - Optional; Default = public. See Modifier. |
-m internal |
Only CLI |
-f / --filter |
The filter which should be used to determine the tables - Optional; Default = Empty. See Filter | -f Person* |
Only CLI |
--sealed |
Adds the sealed modifiert to the classes - Optinal; Default = false. |
--sealed |
Only CLI |
--db-model |
Adds all neded attribute to use the class with Entity Framework Core. - Optional; Default = false |
--db-model |
Only CLI |
--column-attribute |
Adds a Column attribute to each property. - Optional; Default false |
--column-attribute |
Only CLI |
--backing-field |
Creates a backing field for each property. - Optional; Default = false |
--backing-field |
Only CLI |
--set-property |
Adds the SetProperty method to the properties. Note: To use this function, you need to add the CommunityToolkit.Mvvm to your project or implement it by yourself. - Optional; Default = false |
--set-property |
Only CLI |
--summary |
Adds a summary to each property and to the class. - Optional; Default = false |
--summary |
Only CLI |
-c / --clean |
Specifies if the output directory should be cleaned before the class are generated. Note: All *.cs files in the specified directory will be deleted irretrievable! - Optional; Default = false |
-c |
Only CLI |
--table-name |
Adds the name of the table to the class summary. - Optional; Default = false |
--table-name |
Only CLI |
-l / --log-level |
The desired min. log level. See Log level - Optional; Default = 2 |
-l 0 |
Both |
The following modifier are supported:
publicinternalprotectedprotected internal
| Id | Name |
|---|---|
| 0 | Verbose |
| 1 | Debug |
| 2 | Information (default) |
| 3 | Warning |
| 4 | Error |
| 5 | Fatal |
You can use the filter als follows:
| Example | Description |
|---|---|
value |
The name of the table must match the filter value. |
value* |
The name of the table must beginn with the filter value. |
*value |
The name of the table must end with the filter value. |
*value* |
The name of the table must contain the filter value. |
- Color selection
- Update info - Implemented in version v25.54.0.947
Special thank to Hopstarter for the icon > Pyhton icons created by Hopstarter - Flaticon