Database

The database used in the GSIT-Library is Postgres SQL.
The source file to restore the database is in
..\GSITWPF\databases\gsit_database.sql

1. Login to your database server instance
2. Create a database named crm
3. Perform a restore with a command more or less like this:
   psql -h 127.0.0.1 -U postgres -d crm-f …\GSITWPF\databases\gsit_database.sql
4. Change the value of the connection parameter in the file: appsettings.json:

"ConnectionStrings": {
"ConnStr": "Server=127.0.0.1;Port=5432;Database=crm;User Id=postgres;Password=yourpassword;CommandTimeout=20;"
},
   
   change the database name and password.
5. We do database testing together with Web Api Testing.
6. This article below describe schemas in databases: public and tenant owned schemas.