In this post, I will show how to deploy an ASP.NET Core web application with EF Core and PostgreSQL to App Engine on Google Cloud Platform (GCP). Besides, I will show how to use Cloud SQL for PostgreSQL instance from this application.

I will use the following tools:

The sections of this post will be as follows:

About the App

Sign up for Google Cloud

Create the GCP Project

Cloud SQL

Modify the App and Initialize the Database

Check the Database (pgAdmin)

Test

Publish To Google Cloud

Clean up the GCP Project

In the previous post, I demonstrated how to deploy an ASP.NET Core web application starter project to GCP. As it has no database access, it is a simpler version of this one and I recommend you start from there if this is your first deployment to GCP.

If you are ready, let’s get started.

About the App

The application that we will deploy manages a database of TV Shows and its main page looks like below: