Skip to main content

Database configuration

To configure database, open the provided appsettings.json file. There you will find the Database configuration section.

Sample database configuration section
"Database": {
    "provider": "SqlServer",
    "connectionString": "Server=[DB_HOST],1433;Database=MobileAttestation;Integrated Security=False;user id=[DB_USER];password=[DB_PASSWORD];TrustServerCertificate=True"
  }

Configure SQL Server connection​

When using SQL Server, provider must be set to SqlServer, and appropriate connection string provided. Replace connection details as needed.

SqlServer Database section template
"Database": {
    "provider": "SqlServer",
    "connectionString": "Server=[DB_HOST],1433;Database=MobileAttestation;Integrated Security=False;user id=[DB_USER];password=[DB_PASSWORD];TrustServerCertificate=True"
}

Configure Oracle connection​

When using Oracle, provider must be set to Oracle, and appropriate connection string provided. Replace connection details as needed.

Oracle Database section template
"Database": {
    "provider": "Oracle",
    "oracleSqlCompatibility": "DatabaseVersion23", // DatabaseVersion19 | DatabaseVersion21 | DatabaseVersion23
    "connectionString": "Server=[DB_HOST],1433;Database=MobileAttestation;Integrated Security=False;user id=[DB_USER];password=[DB_PASSWORD];TrustServerCertificate=True"
}

Note on oracleSqlCompatibility​

It is optionally possible to provide the compatibility setting. It defaults to DatabaseVersion23. If it is the desired value, the oracleSqlCompatibility can be removed. Possible values are:

  • DatabaseVersion19;
  • DatabaseVersion21;
  • DatabaseVersion23.

It should be matched the actual DB version, since it changes the actual queries that are built.

For more details, see this Issue on GitHub.