====== 2.2 Configurare Database ======

Connessioni database preconfigurate (DSN).

===== Array Databases =====

<code javascript>
"Databases": [
  {
    "Name": "demo",
    "Dialect": "sqlite",
    "ConnectionString": "Data Source=demo.db"
  },
  {
    "Name": "erp",
    "Dialect": "mssql",
    "ConnectionString": "Server=dbserver;Database=ERP;Trusted_Connection=true"
  }
]
</code>

===== Parametri =====

^ Parametro ^ Descrizione ^
| Name | Nome univoco (percorso URL) |
| Dialect | Tipo di database |
| ConnectionString | Stringa di connessione |

===== Dialetti =====

^ Dialect ^ Database ^
| ''mssql'' | SQL Server, Azure SQL |
| ''sqlite'' | SQLite |
| ''mysql'' | MySQL, MariaDB |
| ''postgresql'' | PostgreSQL |

===== Connection Strings =====

**SQL Server:**
<code>
Server=hostname;Database=dbname;User Id=user;Password=pass;TrustServerCertificate=true
</code>

**SQLite:**
<code>
Data Source=%DATA_PATH%\database.db
</code>

**MySQL:**
<code>
Server=hostname;Database=dbname;User=user;Password=pass
</code>

**PostgreSQL:**
<code>
Host=hostname;Database=dbname;Username=user;Password=pass
</code>