PostgreSQL ADO.NET connection

Run a SQL INSERT statement to open and close a connection to Cloud SQL for PostgreSQL by using the ADO.NET System.Data.Common package.

Code sample


To authenticate to Cloud SQL for PostgreSQL, set up Application Default Credentials. For more information, see Set up authentication for a local development environment.

insertTimestamp = DateTime.UtcNow;
    using(var connection = new NpgsqlConnection(_connectionString.ConnectionString))
        using (var insertVoteCommand = connection.CreateCommand())
            insertVoteCommand.CommandText =
                @"INSERT INTO votes (candidate, time_cast) VALUES (@candidate, @time_cast)";
            var candidate = insertVoteCommand.CreateParameter();
            candidate.ParameterName = "@candidate";
            candidate.DbType = DbType.String;
            candidate.Value = team;
            var timeCast = insertVoteCommand.CreateParameter();
            timeCast.ParameterName = "@time_cast";
            timeCast.DbType = DbType.DateTime;
            timeCast.Value = insertTimestamp;
            await insertVoteCommand.ExecuteNonQueryAsync();
    return Content($"Vote successfully cast for '{team}' at time {insertTimestamp}!");
catch (Exception ex)
    // If something goes wrong, handle the error in this
    // section. This might involve retrying or adjusting
    // parameters depending on the situation.
    return StatusCode((int)HttpStatusCode.InternalServerError, ex);

What's next

To search and filter code samples for other Google Cloud products, see the Google Cloud sample browser.