public async Task UpdateNgo(Ngo ngo) { using IDbConnection connection = _sqlConnectionFactory.CreateConnection(); connection.Open(); var sql = new QueryBuilder().Update("ngos", NgosTableColumns) .Where($"Username = @Username").Build(); var ngoEntity = ToNgoEntity(ngo); int rowsAffected = await connection.ExecuteAsync(sql, ngoEntity); if (rowsAffected == 0) { throw new StorageErrorException($"Ngo entity with username {ngo.Username} was not found", 404); } await _locationStore.UpdateLocation(ngo.Username, ngo.Location); }