Database Configuration Setup

Benjamin Vichel

Completed work

Software Engineer

Dot Net Backend Developer

MySQL

.NET

Hospitality

Project Configuration

Before starting the project, you need to create a configuration file with your specific information.

Step: Create the Configuration File

1.In the project's root directory, create a XML file named appsettings.private.config with the following content:

```xml
<?xml version="1.0" encoding="utf-8" ?>
<connectionStrings>
    <add name="PousadaConnection" connectionString="Server=YOUR_SERVER;Port=YOUR_PORT;Database=YOUR_DATABASE;Uid=YOUR_USERNAME;Pwd=YOUR_PASSWORD;" />
</connectionStrings>
```

Replace the placeholder values:

YOUR_SERVER: The address of the database server.

YOUR_PORT: The port used to connect to the database.

YOUR_DATABASE: The name of the database.

YOUR_USERNAME: The username for authentication.

YOUR_PASSWORD: The password for authentication.

⚠️ Important: Storing credentials directly in a configuration file is not secure. It is recommended to use secure credential storage methods, such as environment variables or the Microsoft Configuration API (User Secrets / Azure Key Vault). If you decide to keep the connection string in the file, ensure it is excluded from version control and accessible only to authorized users.

This project is configured to use Aiven as the default database provider. If you wish to use another provider, ensure your connection string matches the required format and parameters.