Oprazi .zproject file for MSSQL

Zontroy Generator is a developer tool for generating source code. Zontroy is compatible with .Net and all .Net frameworks. You can generate C# code using Zontroy IDE or command line of any known IDE such as Visual Studio Code and Visual Studio.

Steps to generate code after cloning project:

1. Create your database using script under "Oprazi.DbScripts\MSSQL" directory and add new tables for code generation.

2. Run Zontroy Code Generator IDE and open Oprazi.zproject file located in main directory of project folder using File -> Open Project menu.

3. After opening project change database connection settings using Project -> Properties menu item or editing Oprazi.zproject file.

4. Reopen project and include entities inside Entity Window.

5. Generate project using Generate button in toolbar.

{
  "Name": "Oprazi",
  "DatabaseType": "MSSQL",
  "Server": ".\\SQLEXPRESS",
  "DatabaseName": "OpraziReact",
  "ConnectionString": "data source=.\\SQLEXPRESS;initial catalog=OpraziReact;user id=sa;password=12345",
  "Username": "sa",
  "Password": "12345",
  "Language": "CSharp",
  "Port": "",
  "IsIntegratedSecurity": false,
  "Entities": [
    {
      "Name": "Bank",
      "Type": 1,
      "TargetName": "Bank",
      "AlternativeName": "",
      "Label": "Bank",
      "RowOrder": 0,
      "Description": "",
      "Extra1": "",
      "Extra2": "",
      "Extra3": "",
      "Extra4": "",
      "Extra5": "",
      "Extra6": "",
      "Extra7": "",
      "Extra8": "",
      "Extra9": "",
      "EntitySchema": {
        "Name": "dbo",
        "User": null,
        "Password": null,
        "TargetName": null,
        "AlternativeName": null,
        "Label": null,
        "RowOrder": null,
        "Description": null,
        "Extra1": null,
        "Extra2": null,
        "Extra3": null,
        "Extra4": null,
        "Extra5": null,
        "Extra6": null,
        "Extra7": null,
        "Extra8": null,
        "Extra9": null,
        "Catalog": {
          "Type": null,
          "Name": "OpraziReact",
          "Server": null,
          "TargetName": null,
          "AlternativeName": null,
          "Label": null,
          "RowOrder": null,
          "Description": null,
          "Extra1": null,
          "Extra2": null,
          "Extra3": null,
          "Extra4": null,
          "Extra5": null,
          "Extra6": null,
          "Extra7": null,
          "Extra8": null,
          "Extra9": null,
          "Project": null,
          "Schemas": []
        },
        "Entities": []
      },
      "Fields": [
        {
          "Name": "Id",
          "EntityName": "Bank",
          "VirtualEntityName": "",
          "EntitySchema": "dbo",
          "TargetName": "Id",
          "AlternativeName": "",
          "Label": "Id",
          "Order": 1,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        },
        {
          "Name": "Name",
          "EntityName": "Bank",
          "VirtualEntityName": "",
          "EntitySchema": "dbo",
          "TargetName": "Name",
          "AlternativeName": "",
          "Label": "Name",
          "Order": 3,
          "Description": "",
          "Extra1": "",
          "Extra2": "",
          "Extra3": "",
          "Extra4": "",
          "Extra5": "",
          "Extra6": "",
          "Extra7": "",
          "Extra8": "",
          "Extra9": ""
        }        
      ],
      "DisplayFields": "Name"
    }
  ]
}