# Oprazi .zproject file for MSSQL

###

*Zontroy Offline Code 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.*

<figure><img src="https://2376111118-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fqa0RxPoDArscnrvdRrnX%2Fuploads%2FYUNIlJJl5zIAWLLV4jsT%2F3.png?alt=media&#x26;token=f21f6233-b4e3-4ff8-a5d6-c997416d1ec7" alt=""><figcaption></figcaption></figure>

```
{
  "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"
    }
  ]
}
```