Note

This guide applies to Steeltoe v3. Please open an issue if you'd like to help update the content for Steeltoe v4.

Using Service Connectors with PostgreSQL Database

This tutorial takes you through setting up a .NET Core application with the PostgreSQL service connector.

Note

For more detailed examples, please refer to the PostgreSql project in the Steeltoe Samples Repository.

First, start a PostgreSQL instance using the Steeltoe dockerfile.

docker run --env POSTGRES_PASSWORD=Steeltoe789 --publish 5432:5432 steeltoeoss/postgresql

Next, create a .NET Core WebAPI that interacts with PostgreSQL

1. Create a new ASP.NET Core WebAPI app with the Steeltoe Initializr

2. Name the project "PostgreSqlConnector"

3. Add the "PostgreSQL" dependency

4. Click Generate to download a zip containing the new project

5. Extract the zipped project and open in your IDE of choice

6. Set the instance address in appsettings.json

   {
     "postgres": {
       "client": {
         "server": "127.0.0.1",
         "port": "5432",
         "username": "postgres",
         "password": "Steeltoe789"
       }
     }
   }
   

   Tip

   Looking for additional params to use when connecting? Have a look at the docs

Run the application

• .NET cli
• Visual Studio

dotnet run <PATH_TO>\PostgreSqlConnector.csproj

Navigate to the endpoint (you may need to change the port number) http://localhost:5000/api/values

Once the app loads in the browser you will see a list of the default database schemas installed with PostgreSQL. "["UTF8","UTF8","UTF8"]"