PostgreSQL ADO.NET connection

Stay organized with collections Save and categorize content based on your preferences.

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


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.